Crecrio, ----- Original Message ----- From: ""Crercio O. Silva"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 3:49 AM Subject: BUG: SHOW TABLE STATUS & InnoDB Tables
> Hi, > > 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? this is the documented behavior. For InnoDB tables it returns an estimate of the row count, based on 8 random dives into the clustered index tree. For MyISAM it returns the accurate number, because MyISAM separately keeps and stores the row count of a table. > 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. > > Thanks, > > []'s > > Crercio O. Silva Best regards, Heikki Innobase Oy (sql database) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php