清理磁盤空間刪除mysql-slow.log和tmp目錄下的文件后，mysql服務(wù)突然無法啟動(dòng)問題的解決辦法

歡迎來到藍(lán)隊(duì)云技術(shù)小課堂，每天分享一個(gè)技術(shù)小知識(shí)。

問題描述：

服務(wù)器磁盤空間快滿了，清理了下磁盤空間刪除mysql-slow.log和tmp目錄下的文件后，mysql服務(wù)突然無法啟動(dòng)了

問題排查：

查看mysql啟動(dòng)錯(cuò)誤日志如下

2025-02-08T07:12:54.272540Z 0 [Note] Binlog end

2025-02-08T07:12:54.272770Z 0 [Note] Shutting down plugin ＇ngram＇

2025-02-08T07:12:54.272781Z 0 [Note] Shutting down plugin ＇partition＇

2025-02-08T07:12:54.272784Z 0 [Note] Shutting down plugin ＇BLACKHOLE＇

2025-02-08T07:12:54.272788Z 0 [Note] Shutting down plugin ＇ARCHIVE＇

2025-02-08T07:12:54.272790Z 0 [Note] Shutting down plugin ＇PERFORMANCE_SCHEMA＇

2025-02-08T07:12:54.272829Z 0 [Note] Shutting down plugin ＇MRG_MYISAM＇

2025-02-08T07:12:54.272832Z 0 [Note] Shutting down plugin ＇MyISAM＇

2025-02-08T07:12:54.272843Z 0 [Note] Shutting down plugin ＇INNODB_SYS_VIRTUAL＇

2025-02-08T07:12:54.272846Z 0 [Note] Shutting down plugin ＇INNODB_SYS_DATAFILES＇

2025-02-08T07:12:54.272849Z 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLESPACES＇

2025-02-08T07:12:54.272852Z 0 [Note] Shutting down plugin ＇INNODB_SYS_FOREIGN_COLS＇

2025-02-08T07:12:54.272855Z 0 [Note] Shutting down plugin ＇INNODB_SYS_FOREIGN＇

2025-02-08T07:12:54.272857Z 0 [Note] Shutting down plugin ＇INNODB_SYS_FIELDS＇

2025-02-08T07:12:54.272860Z 0 [Note] Shutting down plugin ＇INNODB_SYS_COLUMNS＇

2025-02-08T07:12:54.272870Z 0 [Note] Shutting down plugin ＇INNODB_SYS_INDEXES＇

2025-02-08T07:12:54.272873Z 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLESTATS＇

2025-02-08T07:12:54.272875Z 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLES＇

2025-02-08T07:12:54.272878Z 0 [Note] Shutting down plugin ＇INNODB_FT_INDEX_TABLE＇

2025-02-08T07:12:54.272881Z 0 [Note] Shutting down plugin ＇INNODB_FT_INDEX_CACHE＇

2025-02-08T07:12:54.272883Z 0 [Note] Shutting down plugin ＇INNODB_FT_CONFIG＇

2025-02-08T07:12:54.272886Z 0 [Note] Shutting down plugin ＇INNODB_FT_BEING_DELETED＇

2025-02-08T07:12:54.272889Z 0 [Note] Shutting down plugin ＇INNODB_FT_DELETED＇

2025-02-08T07:12:54.272891Z 0 [Note] Shutting down plugin ＇INNODB_FT_DEFAULT_STOPWORD＇

2025-02-08T07:12:54.272894Z 0 [Note] Shutting down plugin ＇INNODB_METRICS＇

2025-02-08T07:12:54.272896Z 0 [Note] Shutting down plugin ＇INNODB_TEMP_TABLE_INFO＇

2025-02-08T07:12:54.272899Z 0 [Note] Shutting down plugin ＇INNODB_BUFFER_POOL_STATS＇

2025-02-08T07:12:54.272902Z 0 [Note] Shutting down plugin ＇INNODB_BUFFER_PAGE_LRU＇

2025-02-08T07:12:54.272904Z 0 [Note] Shutting down plugin ＇INNODB_BUFFER_PAGE＇

2025-02-08T07:12:54.272907Z 0 [Note] Shutting down plugin ＇INNODB_CMP_PER_INDEX_RESET＇

2025-02-08T07:12:54.272910Z 0 [Note] Shutting down plugin ＇INNODB_CMP_PER_INDEX＇

2025-02-08T07:12:54.272912Z 0 [Note] Shutting down plugin ＇INNODB_CMPMEM_RESET＇

2025-02-08T07:12:54.272915Z 0 [Note] Shutting down plugin ＇INNODB_CMPMEM＇

2025-02-08T07:12:54.272917Z 0 [Note] Shutting down plugin ＇INNODB_CMP_RESET＇

2025-02-08T07:12:54.272920Z 0 [Note] Shutting down plugin ＇INNODB_CMP＇

2025-02-08T07:12:54.272923Z 0 [Note] Shutting down plugin ＇INNODB_LOCK_WAITS＇

2025-02-08T07:12:54.272925Z 0 [Note] Shutting down plugin ＇INNODB_LOCKS＇

2025-02-08T07:12:54.272928Z 0 [Note] Shutting down plugin ＇INNODB_TRX＇

2025-02-08T07:12:54.272931Z 0 [Note] Shutting down plugin ＇InnoDB＇

2025-02-08T07:12:54.272974Z 0 [Note] InnoDB: FTS optimize thread exiting.

2025-02-08T07:12:54.273025Z 0 [Note] InnoDB: Starting shutdown...

2025-02-08T07:12:54.373128Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool

2025-02-08T07:12:54.373405Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240430 15:12:54

2025-02-08T07:12:55.904370Z 0 [Note] InnoDB: Shutdown completed; log sequence number 56328243996

2025-02-08T07:12:55.906446Z 0 [Note] InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂

2025-02-08T07:12:55.906458Z 0 [Note] Shutting down plugin ＇MEMORY＇

2025-02-08T07:12:55.906464Z 0 [Note] Shutting down plugin ＇CSV＇

2025-02-08T07:12:55.906468Z 0 [Note] Shutting down plugin ＇sha256_password＇

2025-02-08T07:12:55.906471Z 0 [Note] Shutting down plugin ＇mysql_native_password＇

2025-02-08T07:12:55.906603Z 0 [Note] Shutting down plugin ＇binlog＇

2025-02-08T07:12:55.919356Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

解決辦法：

原因：/tmp/mysql.sock.lock 文件為空導(dǎo)致的

解決：手動(dòng)刪除/tmp/mysql.sock.lock 文件，重啟mysql測(cè)試啟動(dòng)正常

藍(lán)隊(duì)云官網(wǎng)上擁有完善的技術(shù)支持庫(kù)可供參考，大家可自行查閱，更多技術(shù)問題，可以直接咨詢。同時(shí)，藍(lán)隊(duì)云整理了運(yùn)維必備的工具包免費(fèi)分享給大家使用，需要的朋友可以直接咨詢。

更多技術(shù)知識(shí)，藍(lán)隊(duì)云期待與你一起探索。