RE: SHOW TABLE STATUS InnoDB Tables

2002-07-03 Thread Bert VdB 

From the manual :

Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimization. Table and index reserved
sizes in bytes are accurate, though. 

CB.

-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 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 Tables).
I'm using MySQL 3.23.49Max on WIN2K.

How to repeat the problem:

Execute the statement SHOW TABLE STATUS many times. In some times (not all)
it will return different number of rows for the same table.
Have anyone else experienced this with other versions?

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 that.

Thanks,

[]'s

Crercio O. Silva


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SHOW TABLE STATUS InnoDB Tables

2002-07-02 Thread Heikki Tuuri 

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 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 statement SHOW TABLE STATUS many times. In some times (not
all)
 it will return different number of rows for the same table.
 Have anyone else experienced this with other versions?

this is the documented behavior. For InnoDB tables it returns an estimate of
the row count, based on 8 random dives into the clustered index tree. For
MyISAM it returns the accurate number, because MyISAM separately keeps and
stores the row count of a table.

 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 that.

 Thanks,

 []'s

 Crercio O. Silva

Best regards,

Heikki
Innobase Oy
(sql database)




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php