Re: Utilize maximum system resources for better performance

[Ronald Brown]

I Have creatd compound indexes to speedup queries but still there are few queries that take ages to comple like this one.,


mysql> explain SELECT content.title, content.og_name, content.record_num, content.category, content.upload_date, content.hash, content.comments_count, content.verified, content.uploader, content.size,content.seeders,content.leechers FROM content WHERE enabled = 1 ORDER BY upload_date DESC LIMIT 6514850,25\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: content
type: ref
possible_keys: e_c_d_v,e_d_v,e_c_v,e_v,e,e_u
key: e_d_v
key_len: 1
ref: const
rows: 6514945
Extra: Using where
1 row in set (0.00 sec)