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
Subject
Views
Written By
Posted
2525
November 08, 2005 05:04AM
Re: Slow Query Time for Many Records from Large Table
1371
November 08, 2005 08:08AM
1330
November 08, 2005 02:21PM
1371
November 08, 2005 02:40PM
1371
November 08, 2005 03:34PM
1464
November 08, 2005 04:10PM
1417
November 08, 2005 05:09PM
1548
November 08, 2005 09:51PM
1316
November 11, 2005 05:54AM
1341
November 08, 2005 08:05PM
1322
November 11, 2005 06:10AM
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.