清理磁盘空间删除mysql-slow.log和tmp目录下的文件后，mysql服务突然无法启动问题的解决办法

欢迎来到蓝队云技术小课堂，每天分享一个技术小知识。

问题描述：

服务器磁盘空间快满了，清理了下磁盘空间删除mysql-slow.log和tmp目录下的文件后，mysql服务突然无法启动了

问题排查：

查看mysql启动错误日志如下

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 文件为空导致的

解决：手动删除/tmp/mysql.sock.lock 文件，重启mysql测试启动正常

蓝队云官网上拥有完善的技术支持库可供参考，大家可自行查阅，更多技术问题，可以直接咨询。同时，蓝队云整理了运维必备的工具包免费分享给大家使用，需要的朋友可以直接咨询。

更多技术知识，蓝队云期待与你一起探索。