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 Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.1.6 OS:Windows (windows2000 server)
Assigned to: 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).