MySQL appears the problem with the table ' xxxxx ' is full

Tag: the map ini localhost dev BSP mysq configuration is present in main

This problem occurs, the first reaction is full, the disk is full, but the server is new open not long, should not Ah,

Then my friend sent me an article. Let me change this, I did not think much, and so on.

So just modify the MySQL configuration file My.ini, add/Modify two lines under [mysqld]: tmp_table_size = 256mmax_heap_table_size = 256M system default is 16M, after modification, restart MySQL

　　

Upload my.cnf, restart MySQL

Well, this tragedy, MySQL does not come up, look at the Localhost.localdomain.err error file, for 0KB,

Okay, calm down. When the error file is written to 0KB, first look at disk space df-l,

Oh my god,,/dev/mapper/volgroup-lv_root usage rate 100%, day.

Think first to see where the file occupies relatively large, toss 2 hours, the results found no very large files.

All said to restart the cure, holding the idea of a try, I will restart,

Mom eggs, with df-l looked under,/dev/mapper/volgroup-lv_root use rate 11%, look under the MySQL service, normal ...

Come on, which elder brother, can help me to see what this is the problem. It's good to reboot ... That's the old saying, to restart the cure for all ills.

MySQL appears the problem with the table ' xxxxx ' is full