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 -
So, now this has made me think here. If 'SHOW TABLE STATUS' only shows
an "estimate" of the number of rows contained in a table, how accurate
is the rest of the data in 'SHOW TABLE STATUS'?
What I'm looking for is to try to find some exact numbers, such as
physical data size on disk, queries/second, etc etc. An "estimate"
would not give me a very good idea of what I'm looking at.
Is there a more accurate way of getting table information, aside from
'SHOW TABLE STATUS'?
THanks!
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
