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:
- MySQL exclude error 1114 holmium HY000 41 holmium“
- How to Solve Mysql Error 1206: The total number of locks exceeds the lock table size
- Prepared statement needs to be re prepared
- Incorrect key file for table [How to Solve]
- [Solved] Plugin ‘FEDERATED’ is disabled. /usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’…
- [Solved] Greenplum Use the Storage Error: function cannot execute on a QE slice because it accesses relation
- Mysqldump common error reports and Solutions
- [Solved] cannot load from mysql.proc. the table is probably corrupted
- Mysql Error when creating table: Tablespace for table `tablexx` exists. Please DISCARD the tablespace before IMPORT.
- [Solved] SQL Server Error: Cannot drop database XXX because it is currently in use