故障案例:磁碟空間不足可能引起的mysql問題,案例mysql

來源:互聯網
上載者:User

故障案例:磁碟空間不足可能引起的mysql問題,案例mysql

此前在工作中,因為客戶的磁碟空間警示沒怎麼注意,空間不足引起了以下可能發生的mysql問題

1    mysql進程起不來

2    mysql無法正常關閉,必須kill -9

3    mysql能起來,但是使用者串連失敗,telnet  3306連接埠不通

4    mysql能串連上,但是會阻塞大部分查詢,比如能showprocesslist,但是select * frominformation_schema.processlist 時會報錯:Incorrect key filefor table 'sql-5.5/47c6ab14-b805-4cd3-bbe0-b8a866927d5a/tmp/#sql_344a_0.MYI';try to repair it

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.