【已解决】MySQL 5.7.44无法启动
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：9.2系统版本：OpenCloudOS 9
问题描述：提示磁盘满了，检查了一遍发现是/www/server/data 这个文件夹里面占用很大，搜了一圈，参照https://www.bt.cn/bbs/thread-53754-1-1.html删除了开头是mysql-bin.0000xx 的文件，主要也是这些文件占据磁盘，一个1G，几十个，删除之后发现MySQL没有启动，结果MySQL无法启动了，下面粘贴了错误日志
相关截图（日志、错误）：
2024-12-11T06:12:32.979042Z 0 Binlog end
2024-12-11T06:12:32.979106Z 0 Shutting down plugin ＇ngram＇
2024-12-11T06:12:32.979111Z 0 Shutting down plugin ＇partition＇
2024-12-11T06:12:32.979115Z 0 Shutting down plugin ＇BLACKHOLE＇
2024-12-11T06:12:32.979118Z 0 Shutting down plugin ＇ARCHIVE＇
2024-12-11T06:12:32.979127Z 0 Shutting down plugin ＇PERFORMANCE_SCHEMA＇
2024-12-11T06:12:32.979161Z 0 Shutting down plugin ＇MRG_MYISAM＇
2024-12-11T06:12:32.979165Z 0 Shutting down plugin ＇MyISAM＇
2024-12-11T06:12:32.979172Z 0 Shutting down plugin ＇INNODB_SYS_VIRTUAL＇
2024-12-11T06:12:32.979175Z 0 Shutting down plugin ＇INNODB_SYS_DATAFILES＇
2024-12-11T06:12:32.979179Z 0 Shutting down plugin ＇INNODB_SYS_TABLESPACES＇
2024-12-11T06:12:32.979182Z 0 Shutting down plugin ＇INNODB_SYS_FOREIGN_COLS＇
2024-12-11T06:12:32.979185Z 0 Shutting down plugin ＇INNODB_SYS_FOREIGN＇
2024-12-11T06:12:32.979189Z 0 Shutting down plugin ＇INNODB_SYS_FIELDS＇
2024-12-11T06:12:32.979192Z 0 Shutting down plugin ＇INNODB_SYS_COLUMNS＇
2024-12-11T06:12:32.979195Z 0 Shutting down plugin ＇INNODB_SYS_INDEXES＇
2024-12-11T06:12:32.979199Z 0 Shutting down plugin ＇INNODB_SYS_TABLESTATS＇
2024-12-11T06:12:32.979202Z 0 Shutting down plugin ＇INNODB_SYS_TABLES＇
2024-12-11T06:12:32.979205Z 0 Shutting down plugin ＇INNODB_FT_INDEX_TABLE＇
2024-12-11T06:12:32.979208Z 0 Shutting down plugin ＇INNODB_FT_INDEX_CACHE＇
2024-12-11T06:12:32.979212Z 0 Shutting down plugin ＇INNODB_FT_CONFIG＇
2024-12-11T06:12:32.979215Z 0 Shutting down plugin ＇INNODB_FT_BEING_DELETED＇
2024-12-11T06:12:32.979218Z 0 Shutting down plugin ＇INNODB_FT_DELETED＇
2024-12-11T06:12:32.979221Z 0 Shutting down plugin ＇INNODB_FT_DEFAULT_STOPWORD＇
2024-12-11T06:12:32.979225Z 0 Shutting down plugin ＇INNODB_METRICS＇
2024-12-11T06:12:32.979228Z 0 Shutting down plugin ＇INNODB_TEMP_TABLE_INFO＇
2024-12-11T06:12:32.979231Z 0 Shutting down plugin ＇INNODB_BUFFER_POOL_STATS＇
2024-12-11T06:12:32.979234Z 0 Shutting down plugin ＇INNODB_BUFFER_PAGE_LRU＇
2024-12-11T06:12:32.979238Z 0 Shutting down plugin ＇INNODB_BUFFER_PAGE＇
2024-12-11T06:12:32.979241Z 0 Shutting down plugin ＇INNODB_CMP_PER_INDEX_RESET＇
2024-12-11T06:12:32.979244Z 0 Shutting down plugin ＇INNODB_CMP_PER_INDEX＇
2024-12-11T06:12:32.979248Z 0 Shutting down plugin ＇INNODB_CMPMEM_RESET＇
2024-12-11T06:12:32.979251Z 0 Shutting down plugin ＇INNODB_CMPMEM＇
2024-12-11T06:12:32.979254Z 0 Shutting down plugin ＇INNODB_CMP_RESET＇
2024-12-11T06:12:32.979258Z 0 Shutting down plugin ＇INNODB_CMP＇
2024-12-11T06:12:32.979261Z 0 Shutting down plugin ＇INNODB_LOCK_WAITS＇
2024-12-11T06:12:32.979264Z 0 Shutting down plugin ＇INNODB_LOCKS＇
2024-12-11T06:12:32.979268Z 0 Shutting down plugin ＇INNODB_TRX＇
2024-12-11T06:12:32.979271Z 0 Shutting down plugin ＇InnoDB＇
2024-12-11T06:12:32.979479Z 0 InnoDB: FTS optimize thread exiting.
2024-12-11T06:12:32.979599Z 0 InnoDB: Starting shutdown...
2024-12-11T06:12:33.079838Z 0 InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2024-12-11T06:12:33.080063Z 0 InnoDB: Buffer pool(s) dump completed at 241211 14:12:33
2024-12-11T06:12:34.593552Z 0 InnoDB: Shutdown completed; log sequence number 54983912989
2024-12-11T06:12:34.593720Z 0 InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂
2024-12-11T06:12:34.593730Z 0 Shutting down plugin ＇MEMORY＇
2024-12-11T06:12:34.593735Z 0 Shutting down plugin ＇CSV＇
2024-12-11T06:12:34.593739Z 0 Shutting down plugin ＇sha256_password＇
2024-12-11T06:12:34.593742Z 0 Shutting down plugin ＇mysql_native_password＇
2024-12-11T06:12:34.593844Z 0 Shutting down plugin ＇binlog＇
2024-12-11T06:12:34.603916Z 0 /www/server/mysql/bin/mysqld: Shutdown complete
自己解决了，我遇到的问题：磁盘爆满，mysql启动不了，说下解决方法，大家可以参考。
1：解决磁盘爆满，删除mysql-bin.0000xx格式的文件（重点，回收站也要删掉，不然还是爆满状态）
2：mysql重新启动，如果还是启动不了，那就过一会再启动，基本就可以启动了
找腾讯技术人员搞了大半天才搞定，心累，就这么简单地问题，唯一卡住的就是没有删回收站，丢，但凡当时把回收站内容删了问题都解决了。回收站内容也占据服务器内存空间{:3_57:} 删除这种，有46个，都是这种名称格式
{:3_50:}怎么没大佬看啊 删除了mysql-bin.0000xx格式的文件之后，磁盘还是爆满 都是mysql的事务日志，不建议手动删除，可以通过配置参数由程序自动清理。
页:
[1]