MySQL Forums
Forum List  »  Performance

Re: Utilize maximum system resources for better performance
Posted by: Ronald Brown
Date: July 14, 2015 01:58AM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Utilize maximum system resources for better performance
1064
July 14, 2015 01:58AM


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.