Hi, this for the archives: I got error messages saying "The table 'File' is full". The table was 4 GB in size. It was on a ext3 filesystem. Switching to xfs didn't help. The solution is: http://dev.mysql.com/doc/refman/5.0/en/full-table.html
Saying: You are using a MyISAM table and the space required for the table exceeds what is allowed by the internal pointer size. If you don't specify the MAX_ROWS table option when you create a table, MySQL uses the myisam_data_pointer_size system variable. From MySQL 5.0.6 on, the default value is 6 bytes, which is enough to allow 256TB of data. Before MySQL 5.0.6, the default value is 4 bytes, which is enough to allow only 4GB of data. See Section 5.2.2, ?Server System Variables?. You can check the maximum data/index sizes by using this statement: SHOW TABLE STATUS FROM database LIKE 'tbl_name'; You also can use myisamchk -dv /path/to/table-index-file. If the pointer size is too small, you can fix the problem by using ALTER TABLE: ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL can't optimize the space required based only on the number of rows. Interesting: http://jeremy.zawodny.com/blog/archives/000796.html -- Volker Sauer * Alexanderstrasse 39/217 * 64283 Darmstadt Telefon: 06151-154260 * Mobil: 0179-6901475 * ICQ#98164307 mailto:[EMAIL PROTECTED] * http://www.volker-sauer.de PGPKey-Fingerprint: DB2611C7B12E0B2739992E4F7E354E4D5DD5D0E0
signature.asc
Description: Digital signature
