Mar
13
This week I had a customer ask me if MySQL or the file system on his server had a 4GB file limitation because he was getting a ‘table full’ type error on one of his large tables. I found posts ab out it everywhere on Google, including MySQL website (http://dev.mysql.com/doc/refman/5.0/en/full-table.html) but I am blogging it anyway.
Apparently it is just an easily fixable file pointer limitation with MySQL 4.x.
Here is the fix:
alter table_name MAX_ROWS = 10000000; (this can take a while)
To fix it for new tables, add this to you /etc/my.cnf:
myisam_data_pointer_size=6
This will allow tables to have up to a 256TB size limit. The default value is 4 which allows up to 4GB.
