, July 03, 2002 01:51
To: [EMAIL PROTECTED]
Subject: BUG: SHOW TABLE STATUS InnoDB Tables
Hi,
I have just noticed that SHOW TABLE STATUS is returning different number of
rows each time you execute the query. This seams to affect only InnoDB
Tables (Although I have tested only with ISAM/MyISAM/InnoDB
Hi,
I have just noticed that SHOW TABLE STATUS is returning different number of
rows each time you execute the query. This seams to affect only InnoDB
Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables).
I'm using MySQL 3.23.49Max on WIN2K.
How to repeat the problem:
Execute
Crecrio,
- Original Message -
From: Crercio O. Silva [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 3:49 AM
Subject: BUG: SHOW TABLE STATUS InnoDB Tables
Hi,
I have just noticed that SHOW TABLE STATUS is returning different number
of
rows each
sql,query
At 21:50 -0300 7/2/02, Crercio O. Silva wrote:
PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables
with large number of rows (my tables have -+ 30 records each) it take a
few seconds to get the results.
This is not a big issue for me, but I'd like to confirm