2
votes
4answers
3k views

How to reduce mysql disk io?

mysql> explain SELECT * -> FROM (`items`) -> WHERE `states` = 'A' -> ORDER BY `updated_date` desc -> LIMIT 20520, 40; ...