The solution of the table is full in MySQL

There is only one reason why the table is full appears in MySQL. The data capacity of the corresponding table reaches the upper limit of the system. Please refer to the official manual for specific restrictions: 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 configuration file/etc/my.cnf of MySQL, and add/modify two lines under [mysqld] (the following values are for reference only, please handle according to the actual situation)

tmp_ table_ Size = 256M// temporary table size

max_ heap_ table_ Size = 256M// memory table size

The system default is 16m. Don’t forget to restart mysql.

Similar Posts: