MySQL "table is full" error
Linode
Linode Staff
in one of the magento installation we are getting this error,
"General error: 1114 The table 'catalog_product_index_price_final_store_temp' is full"
when we have search over the web about it, we seem to have a too low maximum size for your innodb_data_file_path in our my.cnf,
for e.g.
innodb_data_file_path = ibdata1:10M:autoextend:max:512M
we have checked, we have enough space on server,
so , we will need to update my.cnf file, i have searched on WHM as well as Cpanel but didnt found it.
could you please confirm that editing innodb_data_file_path in our my.cnf would be the right solution?
1 Reply
Sometimes this type of error can happen if your Linode is running out of memory, because it will try to use RAM when working with an entire table and if the table is too large it will fail. If this is the case then it's related to RAM and not disk space being full.
The solution from an issue on magento's github is to increase the size of tmp_table_size and max_heap_table_size as updating your innodb_data_file_path:
innodb_data_file_path=ibdata1:10M:autoextend
tmp_table_size=50M
max_heap_table_size=50M
You can't update your my.cnf file from CPanel, so you will need to update the file directly. You can access your Linode via SSH or you can use our Web Lish console to easily access this file from your browser.
I installed MySQL on Centos 7 and found my my.cnf file in /etc/my.cnf. You can edit this file with your favorite text editor. If you've never used a terminal text editor before I suggest using Nano
sudo nano /etc/my.cnf
If your Linode continues to run out of memory even after these changes are made you may want try some optimization using MySQLTuner and if that still does not work you may want to consider resizing your Linode to a plan with more memory.