MySQL "table is full" error

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:


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.


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct