MySQL Forums :: MyISAM :: is read block write?

Advanced Search

Re: is read block write?
Posted by: Rick James ()
Date: October 20, 2011 10:54PM

Data_length: 5959082744
Data_free: 1419788748
Caution: It may take more than an hour to run; all references to the table will be blocked during the OPTIMIZE.

> Rows_sent: 45 Rows_examined: 120460
However, there is no good reason for it to examine more than 45. Perhaps this will make it faster:

select  id, product, cas_no, company, post_date,
        pubDate, mtype_en, poster, cate1
    from  sell s
      ( SELECT  id
            FROM  sell
            order by  pubDate desc
            limit  0,45
       ) x ON =
    where  1
      and  pubDate >= date_add(current_date(), interval -14 day)
    order by  pubDate desc, mtype_en desc, post_date desc;
* If you change the WHERE clause, this may not work as well.
* The exact ordering _may_ be different.

Options: ReplyQuote

Subject Views Written By Posted
is read block write? 2681 h ch 10/10/2011 01:02AM
Re: is read block write? 1616 Rick James 10/12/2011 06:05AM
Re: is read block write? 1112 h ch 10/18/2011 11:50PM
Re: is read block write? 1235 Rick James 10/20/2011 10:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.