Bug #7341 nr. of rows change in schema tables overview (catalogs)
Submitted: 16 Dec 2004 2:02 Modified: 16 Dec 2004 16:19
Reporter: Mark Junker Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.17 OS:Windows (WinXP Pro SP2)
Assigned to: CPU Architecture:Any

[16 Dec 2004 2:02] Mark Junker 
Description:
Hi,

when using InnoDB tables that have more than one data page, the nr. of rows are changing when refreshing the schema tables overview (catalogs) but the server doesn't execute "insert" and "delete" statements.

Regards,
Mark

How to repeat:
1. Create a InnoDB table
2. Insert many rows so that the table needs more than one data page
3. Select "Catalogs" view
4. Select schema containing the table
5. Press "Refresh" button multiple times
[16 Dec 2004 9:41] Jerome Canler 
I had exactly the same problem during restore process : progress stayed at 0%

I solved this by changing the file charset from utf8 to latin1.

So I think there's a problem in the charset auto detection as it tells 'probably utf8'
[16 Dec 2004 15:33] Jerome Canler 
Sorry, please ignore my last comment : it was destined for an other bug.
[16 Dec 2004 16:19] MySQL Verification Team 
Hi,

MySQL Administrator displays number of rows according the ouput of SHOW TABLE STATUS command. For InnoDB tables this command doesn't provide exact number of rows. It gives only an approximate row count.
From the MySQL manual:

Rows 
The number of rows. Some storage engines, such as MyISAM and ISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count.