MySQL Bugs: #26001: Number of rows of table displayed do not agreed with actual number

Bug #26001	Number of rows of table displayed do not agreed with actual number
Submitted:	1 Feb 2007 8:44	Modified:	6 Feb 2007 11:56
Reporter:	Spyros Papantoniou	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.5.rc + 1.2.9	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any
Tags:	displayed number of rows

Description:
The number of rows displayed of a table with 95000 rows  in the administrator window vary  with ever refresh. They jump up and down about + - 1%.The number of rows shown in Query browser [edit tabled data] do not agree with the number of rows displayed in MySQL admin.

How to repeat:
We may send you screen shots as attachments.

Thank you for a problem report. Please, try to repeat with a newer version, 1.2.9 (from GUI Tools 5.0r9), and inform about the results. In case of the same problem, please, send SHOW CREATE TABLE results for the problematic table.

same with 1.2.9

'tr_table_xuts', 'CREATE TABLE `tr_table_xuts` (
  `id` char(20) NOT NULL,
  `OBJ_VERSION` bigint(20) default NULL,
  `pname` varchar(255) default NULL,
  `ptitle` varchar(255) default NULL,
  `powner` char(20) default NULL,
  `pcreated` datetime default NULL,
  `pmodified` datetime default NULL,
  `pmodifier` char(20) default NULL,
  `pacl` char(20) default NULL,
  `plocked` tinyint(4) default NULL,
  `pvcurrent` tinyint(4) default NULL,
  `papproved` tinyint(4) default NULL,
  `pvstring` varchar(255) default NULL,
  `pvroot` char(20) default NULL,
  `pvparent` char(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `tr_table_xuts_pname_idx` (`pname`),
  KEY `tr_table_xuts_ptitle_idx` (`ptitle`),
  KEY `tr_table_xuts_powner_idx` (`powner`),
  KEY `tr_table_xuts_pcreated_idx` (`pcreated`),
  KEY `tr_table_xuts_pmodified_idx` (`pmodified`),
  KEY `tr_table_xuts_pacl_idx` (`pacl`),
  KEY `tr_table_xuts_plocked_idx` (`plocked`),
  KEY `tr_table_xuts_pvcurrent_idx` (`pvcurrent`),
  KEY `tr_table_xuts_pvroot_idx` (`pvroot`),
  KEY `tr_table_xuts_pvparent_idx` (`pvparent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8'

So, it is InnoDB table. Can you repeat this with single active session only or you are checking in multiuser environment?

>So, it is InnoDB table. Can you repeat this with single active session only or
>you are checking in multiuser environment?

The number rows between refreshes are positively constant. No insert updates occur.
The query browser displays the correct (?) at least a constant number of rows. suebsequent query browser executions show the same number of rows. The admin "show tables window" has the fluctuating number.

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of Bug #22888