SHOW STATUS / COUNT(*) Innobase table.

[BAUMEISTER Alexandre]

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.