On Thu, May 30, 2002 at 06:18:46PM +0200, Iago Sineiro wrote: > Hi all. > > I have two questions about InnoDB table type. > > 1) I execute command SHOW TABLE STATUS for a table and the value for column > Rows is different from the result of SELECT COUNT(*) for that table. > > mysql> SHOW TABLE STATUS LIKE 'ALBARANCL'; > +-----------+--------+------------+--------+----------------+-------------+- > ----------------+--------------+-----------+----------------+-------------+- > ------------+------------+----------------+-------------------------+ > | Name | Type | Row_format | Rows | Avg_row_length | Data_length | > Max_data_length | Index_length | Data_free | Auto_increment | Create_time | > Update_time | Check_time | Create_options | Comment | > +-----------+--------+------------+--------+----------------+-------------+- > ----------------+--------------+-----------+----------------+-------------+- > ------------+------------+----------------+-------------------------+ > | ALBARANCL | InnoDB | Dynamic | 862226 | 460 | 397410304 | > NULL | 282361856 | 0 | NULL | NULL | NULL > | NULL | | InnoDB free: 1013760 kB | > +-----------+--------+------------+--------+----------------+-------------+- > ----------------+--------------+-----------+----------------+-------------+- > ------------+------------+----------------+-------------------------+ > 1 row in set (0.54 sec)
InnoDB computes an approximation of the number of rows. This is documented in the InnoDB manual. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 18,403,965 queries (297/sec. avg) --------------------------------------------------------------------- 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