MySQL Forums
Forum List  »  Newbie

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

Written By
Slow access to large tables
June 12, 2012 10:06AM

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.