MySQL Forums
Forum List  »  MyISAM

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

Data_length: 5959082744
Data_free: 1419788748
Recommend:
OPTIMIZE TABLE trade;
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
    JOIN  
      ( SELECT  id
            FROM  sell
            order by  pubDate desc
            limit  0,45
       ) x ON x.id = s.id
    where  1
      and  pubDate >= date_add(current_date(), interval -14 day)
    order by  pubDate desc, mtype_en desc, post_date desc;
Caveats:
* 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
3592
October 10, 2011 01:02AM
2143
October 12, 2011 06:05AM
1684
October 18, 2011 11:50PM
Re: is read block write?
1718
October 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.