MySQL "Table full" error occurred while recovering data

[ERROR]/usr/sbin/mysqld:the table ' cps_effect_confirm_log_1301 ' is

Today to a database recovery data, is a 25G library, in the execution of half is, the occurrence of such an error

One, view the disk space '

DF-DH see that the MySQL directory (not the installation directory) is not a problem.

Second, open the MySQL configuration file my.cnf Modify the size of the two parameters (default is 16)

tmp_table_size=256m

Max_heap_table_size = 256M

Restart MySQL after modification

Check if you have changed in MySQL after reboot

Mysql> show global variables like ' tmp_%_size ';

+----------------+-----------+

| variable_name | Value |

+----------------+-----------+

| Tmp_table_size | 268435456 |

+----------------+-----------+

Mysql> show global variables like '%data_%_path% ';

+-----------------------+-----------------------+

| variable_name | Value |

+-----------------------+-----------------------+

| Innodb_data_file_path | Ibdata1:1g:autoextend |

+-----------------------+-----------------------+

1 row in Set (0.00 sec)

Three, view in MY.CNF

Innodb_data_file_path = ibdata1:1g:autoextend:max:128m

See the size of ibdata1 is already 128M

128M/data/mysql3307/ibdata1

Change the above parameters to

Innodb_data_file_path = Ibdata1:1g:autoextend

To restart MySQL after modification

MySQL "table full" error occurred while recovering data