caiheqing 发表于 2023-9-5 10:16:23

MySQL出现不知原因地自动关闭,内存够,提供日志...

服务器的内存是管够的,我查看一下mysql日志,发日志内容:
2023-09-05 00:01:08 30215 InnoDB: The log sequence numbers 987181250 and 987181250 in ibdata files do not match the log sequence number 987742792 in the ib_logfiles!
2023-09-05 00:01:08 30215 InnoDB: Database was not shutdown normally!
2023-09-05 00:01:08 30215 InnoDB: Starting crash recovery.
2023-09-05 00:01:08 30215 InnoDB: Reading tablespace information from the .ibd files...
2023-09-05 00:01:08 30215 InnoDB: Restoring possible half-written data pages
2023-09-05 00:01:08 30215 InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 270835, file name mysql-bin.000080
2023-09-05 00:01:09 30215 InnoDB: 128 rollback segment(s) are active.
2023-09-05 00:01:09 30215 InnoDB: Waiting for purge to start
2023-09-05 00:01:09 30215 InnoDB: 5.6.51 started; log sequence number 987742792在网上搜索教程,修改my.cnf文件,在my.cnf中的中添加:
innodb_force_recovery = 6
innodb_purge_threads = 1
重启Mysql之后发现文章页面打开不了。首页可以打开。这个方法试了不行。不知道怎么去解决了。求解决方法



licess 发表于 2023-9-5 16:22:32

innodb_force_recovery的值从1到6挨个试试看看它自己能修复不,innodb_purge_threads参数别加
页: [1]
查看完整版本: MySQL出现不知原因地自动关闭,内存够,提供日志...