Hello, > Here is table status: > +-------+--------+------------+---------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+---------------------+---------------------+----------------+---------+ > | 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 | > +-------+--------+------------+---------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+---------------------+---------------------+----------------+---------+ > | linii | MyISAM | Dynamic | 1194745 | 130 | 155429332 | > 4294967295 | 42998784 | 0 | 3472328119327703312 | 2003-04-02 10:48:27 | > 2003-04-02 12:17:14 | 2003-04-02 > 10:50:26 | | | > +-------+--------+------------+---------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+---------------------+---------------------+----------------+---------+
Hmm. I should have told you to issue "SHOW TABLE STATUS LIKE 'linii'\G". \G would produce a more readable output. Anyway: Data_free = 0 says it all. There is no more space in that table, thus MySQL reports "the table is full". Most possibly, you have hit a filesystem limit (2 or 4 GB) for the data or the index file of that table. To solve your problem, you could do one or more of the following: a) Use another storage engine for the table, e.g. InnoDB. b) Split up that table into many small once, and create MERGE tables from those smaller MyISAM tables if you need to SELECT from the big table. c) Use another filesystem that supports bigger files. Hope that helps. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
