Bug #16036 the table's record rows displayed in administrator is not exact

• Submitted: 28 Dec 2005 10:10
• Modified: 16 Jan 2006 13:15
• Reporter: ming lu
• Status: Can't repeat
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.1.6
• OS: Windows (windows2000 server)
• CPU Architecture: Any

[28 Dec 2005 10:10] ming lu

Description:
The table's record rows displayed in administrator is not exact.

How to repeat:
Produce some large tables with the program like Tpc-W(400EB, 2000Item). Run the administrator and look at the table's record rows. The number is not exact, it is not same as the result —— "select count(*) from the table_name".

[28 Dec 2005 10:52] Valeriy Kravchuk

Thank you for a problem report. Please, try the newer version, 1.1.6 for Windows, and inform about the results.

How large are that tables? How many rows - what is the exact value returned from "select count(*) from test_table"?

[13 Jan 2006 6:13] ming lu

I do the test against to the administrator v1.1.6 and server v5.0.18 in windows platform. The problem still exists.
I create a table t1 and insert 1220records into it. 
'select count(*) from t1' returns a correct result. but the administrator catalogs -> schematables displays a wrong number. The rows value would change when you refresh tables every time.It may be 775,1549,1339 etc.

[16 Jan 2006 13:15] Valeriy Kravchuk

Sory, but I was not able to repeat with simple tables, both InnoDB and MyISAM, in a single user environment. MySQL Administrator 1.1.6 shows correct number of rows for me (after the refresh).