Dan Trainor wrote:
Hello, all -

Still kidna new to MySQL, so please forgive me if this is somewhat dumb question...

When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows column for my table, I see 17333. However, when issuing a 'COUNT (*) FROM table', I see 17203 - a difference of 130.

We're really pounding this database, but I wouldn't expect any sort of data to become out of sync. Is this a corruption of tables? We're using the InnoDB storage engine for this particular table, if that helps.

Thanks!
-dant


Hi -

For the record -

http://bugs.mysql.com/bug.php?id=5755

I now understand the problem.

Thanks!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to