day, 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
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 confir
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
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 the