SHOW STATUS / COUNT(*) Innobase table.

[BAUMEISTER Alexandre <alex@xxxxxxxxxxxxxxx>]

Bonjour,

  I have a table with 111619 rows in it.

  "show  table  status"  and  "select  count(*)" don't return the same
  number of rows.

  Is this know ?

mysql> show table status like 'livequote_FSE';
+---------------+----------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------
------+----------------+----------------------------+
| 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                    |
+---------------+----------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------
------+----------------+----------------------------+
| livequote_FSE | Innobase | Fixed      | 172281 |            119 |    20529152 |            NULL |            0 |         0 |           NULL | NULL        | NULL        | NULL
      |                | ; Innobase free: 459776 kB |
+---------------+----------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------
------+----------------+----------------------------+
1 row in set (0.19 sec)

mysql> select count(*) from livequote_FSE;
+----------+
| count(*) |
+----------+
|   111619 |
+----------+
1 row in set (0.22 sec)

  Regards,
  Alex.



---------------------------------------------------------------------
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 <mysql-thread68973@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php