MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Slow access to large tables
Posted by: Peter Brawley
Date: June 12, 2012 11:08AM

A serious & largely unsolved problem with InnoDB, lots has been written about it eg http://mysqlha.blogspot.com/2009/08/fast-count-for-innodb.html. Adding a USING INDEX clause can speed up the count, esp. if the index is primary.



Edited 1 time(s). Last edit at 06/12/2012 11:11AM by Peter Brawley.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Slow access to large tables
Peter Facey
June 12, 2012 10:06AM
Re: Slow access to large tables
Peter Brawley
June 12, 2012 11:08AM
Re: Slow access to large tables
Peter Facey
June 12, 2012 02:12PM
Re: Slow access to large tables
Rick James
June 14, 2012 09:46AM
Re: Slow access to large tables
Peter Brawley
June 14, 2012 10:26AM


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.