Hi,

I just run an ANALYZE TABLE on a table with Delayed_insert... (with MySQL
3.23.37)

Here is what it returned :

mysql> SHOW INDEX from searchhardwarefr1; +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Comment | +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+---------+ | searchhardwarefr1 | 0 | PRIMARY | 1 | mot | A
| NULL | NULL | NULL | | | searchhardwarefr1 | 0 | PRIMARY | 2 | topic | A
| 56186 | NULL | NULL | | | searchhardwarefr1 | 1 | numreponse | 1 | numreponse | A
| NULL | NULL | NULL | | | searchhardwarefr1 | 1 | date | 1 | date | A
| NULL | NULL | NULL | | | searchhardwarefr1 | 1 | pseudo | 1 | pseudo | A
| NULL | NULL | NULL | | +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+---------+ 5 rows in set (0.02 sec)

mysql> ANALYZE TABLE searchhardwarefr1; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | Hardwarefr.searchhardwarefr1 | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.70 sec)

mysql> SHOW INDEX from searchhardwarefr1; ERROR 1016: Can't open file: 'searchhardwarefr1.MYD'. (errno: 145)

is this fixed with MySQL 3.23.39 ?

Jocelyn Fournier Presence-PC www.presence-pc.com