MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Bert VdB Date:July 3 2002 9:05am
Subject:RE: SHOW TABLE STATUS & InnoDB Tables
View as plain text  
From the manual :

Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimization. Table and index reserved
sizes in bytes are accurate, though. 


-----Original Message-----
From: Crercio O. Silva [mailto:cos@stripped]
Sent: Wednesday, July 03, 2002 01:51
To: mysql@stripped
Subject: BUG: SHOW TABLE STATUS & InnoDB Tables


I have just noticed that SHOW TABLE STATUS is returning different number of
rows each time you execute the query. This seams to affect only InnoDB
Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables).
I'm using MySQL 3.23.49Max on WIN2K.

How to repeat the problem:

Execute the statement SHOW TABLE STATUS many times. In some times (not all)
it will return different number of rows for the same table.
Have anyone else experienced this with other versions?

PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables
with large number of rows (my tables have -+ 300000 records each) it take a
few seconds to get the results.
This is not a big issue for me, but I'd like to confirm that.



Crercio O. Silva

Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread113641@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try:
Re: SHOW TABLE STATUS & InnoDB TablesHeikki Tuuri3 Jul
RE: SHOW TABLE STATUS & InnoDB TablesBert VdB3 Jul