MySQL Forums
Forum List  »  Connector/Python

COUNT(*) on innodb
Posted by: Jacky Shu
Date: November 24, 2005 09:13AM


I ran an experiment on an innodb table (10Million rows).
I used count(*) to monitor the table growth.
Unfortunately, I found it needed 8 minutes.
If I use SHOW TABLE STATUS, it only gives me an estimated row number.
Is there any other ways to work around?

Thank you very much,


Options: ReplyQuote

Written By
COUNT(*) on innodb
November 24, 2005 09:13AM
November 24, 2005 09:14AM

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.