MySQL Forums :: Newbie :: Slow access to large tables


Advanced Search

Slow access to large tables
Posted by: Peter Facey ()
Date: June 12, 2012 10:06AM

I have an InnoDB table containing 80.6 million rows. Its Data_length is 40.6 GB. Just saying SELECT COUNT(*) takes 1 hour 16 minutes. Admittedly, it is stored on a USB disk, but I'm surprised given that there must be an index on the prime key that it can't answer this question faster.

Am I doing something wrong?

6GB RAM, Intel E6600 2.4GHz.
Windows 7 pro, 64-bit.



Edited 1 time(s). Last edit at 06/12/2012 10:14AM by Peter Facey.

Options: ReplyQuote


Subject Written By Posted
Slow access to large tables Peter Facey 06/12/2012 10:06AM
Re: Slow access to large tables Peter Brawley 06/12/2012 11:08AM
Re: Slow access to large tables Peter Facey 06/12/2012 02:12PM
Re: Slow access to large tables Rick James 06/14/2012 09:46AM
Re: Slow access to large tables Peter Brawley 06/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.