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.