Menu
I have a MySQL InnoDB table on a RedHat Enterprise Linux 4 server, and after trying to import a database previously backed up using mysqldump I got a "the table is full" error.
The table currently has 463,062 rows in it, and the ibdata1 file on disk is currently 3.37Gb. A quick "SHOW VARIABLES;" shows that the innodb_data_file_path is set to ibdata1:10M:autoextend, and the filesystem is ext3, so I'd expect it to have plenty of room left to grow.
Any ideas how I can go about establishing exactly what the problem is?
898
MySQL Error: The Table is Full Solution. The solution to this error is pretty straightforward. You need to change the max value for the key 'innodb_data_file_path' to a larger value and then save the config file. After this, restart your MySQL dB.
Disk Full If a server partition or disk has used up all the space and MySQL still attempts to insert data into the table, it will fail with error 1114. Similarly, this error can also happen during backup of large databases too.
In InnoDB, with a limit on table size of 64 terabytes and a MySQL row-size limit of 65,535 there can be 1,073,741,824 rows.
You are using a MyISAM table and the space required for the table exceeds what is permitted by the internal pointer size. MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).
If I was you I would try actually setting the last part of the innodb_data_file_path command i.e. innodb_data_file_path ibdata1:10M:autoextend:max:3999M
Not specifying the large number can sometimes have it default to unpredicatable numbers.
Not to be too obvious but ensure you restart after making the config change!
100
Check that the disk the InnoDB data file is stored on isn't full
27
We fixed the exact same issue on CentOS on AWS. Contray to what most of the posts indicate, this can be fixed by adding right below the [mysqld] section in your my.cnf file:
innodb_data_file_path=ibdata1:10G:autoextend
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
