MySQL Forums
Forum List  »  Performance

Re: Slow Query Time for Many Records from Large Table
Posted by: Jay Pipes
Date: November 08, 2005 08:08AM

Could you post an EXPLAIN SELECT of your slower queries? Also, how often do you run an ANALYZE TABLE on this particular table and how many INSERTs/sec are you experiencing during average and peak loads? It sounds like it may just be a case of poor key distribution across the index tree.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow Query Time for Many Records from Large Table
1371
November 08, 2005 08:08AM


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.