Failure case: MySQL problem may be caused by insufficient disk space

Earlier in the work. Due to the customer's disk space alarm did not pay much attention. The lack of space causes the following MySQL problem to occur

1 MySQL process does not come up

2 MySQL does not shut down properly and must be kill-9

3 MySQL can get up, but the user connection fails. Telnet 3306port does not pass

4 MySQL can connect, but it will clog most queries. For example, you can showprocesslist, but select * frominformation_schema.processlist error: Incorrect key filefor table ' sql-5.5/ 47c6ab14-b805-4cd3-bbe0-b8a866927d5a/tmp/#sql_344a_0. MYI '; try to repair it

Failure case: MySQL problem may be caused by insufficient disk space