MySQL 5.0.18 AIX 5.2 Binary large file support?

[Mike Magowan]

Hi All,

Hope someone can help me with this problem.

We have a table on our database that keeps getting the dreaded 'table full' error. It does this on reaching 2Gb. This is running on AIX 5.2 (32bit version) on a JFS filesystem (with largefile support turned on).

The filesystem and security settings are ok as I have logged on as the mysql user and manually created a 4Gb file with no problems. I have already done an ALTER TABLE and set the 'AVG_ROW_LENGTH' and 'MAX_ROWS' to a fairly large number but the 'Max_data_length' doesn't seem to waver from 2147483647.

The only thing I can seem to find is that as we use the AIX5.2 Binary version downloaded from mysql.com (mysql-standard-5.0.18-aix5.2-powerpc.tar.gz) the 'large files support' is set to OFF but I'm unsure as to if this actually affects things on the AIX platform (I'm guessing it does - although unsure as to why it was explicitly disabled on the compile).

Here is the result of SHOW TABLE STATUS for the table in question:

mysql> show table status like 'record' \G
*************************** 1. row ***************************
Name: record
Engine: MyISAM
Version: 9
Row_format: Dynamic
Rows: 3436810
Avg_row_length: 624
Data_length: 2147483592
Max_data_length: 2147483647
Index_length: 35612672
Data_free: 0
Auto_increment: NULL
Create_time: 2006-02-13 13:11:18
Update_time: 2006-02-13 15:32:08
Check_time: 2006-02-13 13:28:13
Collation: latin1_swedish_ci
Checksum: 2319930331
Create_options: max_rows=2820130816 avg_row_length=500 pack_keys=1 checksum=1 delay_key_write=1
Comment: Table holds all MF data


Can anyone suggest anything that I may have missed?

Kind Regards,

Mike.