Re: BUG: MyCC 0.8.4 incorrect row count after changing table type to INNODB - Heikki Tuuri - com.mysql.lists.bugs

5 messages in com.mysql.lists.bugsRe: BUG: MyCC 0.8.4 incorrect row cou...

From	Sent On	Attachments
Paul Dixon	09 Oct 2002 13:38
Peter Zaitsev	10 Oct 2002 13:03
Mark Armer	11 Oct 2002 09:54
Heikki Tuuri	11 Oct 2002 12:22
Mark Matthews	11 Oct 2002 16:18

Subject:	Re: BUG: MyCC 0.8.4 incorrect row count after changing table type to INNODB
From:	Heikki Tuuri (Heik...@innodb.com)
Date:	10/11/2002 12:22:15 PM
List:	com.mysql.lists.bugs

For the mail filter:

How-To-Repeat:

Mark,

I guess MyCC uses SHOW TABLE STATUS to determine COUNT(*) of a table to the MyCC display. For InnoDB it only gives an approximate value based on 10 random dives into the table's clustered index tree.

It is my plan to implement a fast COUNT(*) for InnoDB in 2002 or 2003. Then we will get the accurate number instantaneously, just like for MyISAM type tables.

Best regards,

Heikki Innobase Oy

Copied message: ....................... Hi,

I am using MYCC v.0.8.4 alpha and MySQL 4.0.4. I have several tables that when I switch the table type from MyISAM to InnoDB MyCC returns an incorrect number of records display. If I open a SQL window and execute a 'Select count(*)' against any of the InnoDB tables I do get the correct record count. Refreshing the display in MyCC has no effects.