Solution for MySQL to show The table is full

There is only one reason for MySQL to show that The table is full. The corresponding table data capacity has reached The system limit. For specific restrictions, see the official manual: http://dev.mysql.com/doc/refman/5.1/zh/introduction.html?table-size. You can use the show table status statement to view information about the TABLE.

Solution 1:
Execute alter table tbl_name MAX_ROWS = 1000000000;

Solution 2:
Modify the Mysql configuration file/etc/my. cnf and add/modify two rows under [mysqld] (the following values are for reference only. Please handle them as appropriate ):
Tmp_table_size = 256 M // temporary table size
Max_heap_table_size = 256 M // memory table size

The default value is 16 Mb. Do not forget to restart mysql.

This article is from the Neure blog, please be sure to keep this source http://neure.blog.51cto.com/3029236/1294062