VPS侦探论坛

标题: MySQL出现不知原因地自动关闭，内存够，提供日志... [打印本页]

---

作者: caiheqing    时间: 2023-9-5 10:16
标题: MySQL出现不知原因地自动关闭，内存够，提供日志...
服务器的内存是管够的，我查看一下mysql日志，发日志内容：

1. 2023-09-05 00:01:08 30215 [Note] InnoDB: The log sequence numbers 987181250 and 987181250 in ibdata files do not match the log sequence number 987742792 in the ib_logfiles!
   
2. 2023-09-05 00:01:08 30215 [Note] InnoDB: Database was not shutdown normally!
   
3. 2023-09-05 00:01:08 30215 [Note] InnoDB: Starting crash recovery.
   
4. 2023-09-05 00:01:08 30215 [Note] InnoDB: Reading tablespace information from the .ibd files...
   
5. 2023-09-05 00:01:08 30215 [Note] InnoDB: Restoring possible half-written data pages
   
6. 2023-09-05 00:01:08 30215 [Note] InnoDB: from the doublewrite buffer...
   
7. InnoDB: Last MySQL binlog file position 0 270835, file name mysql-bin.000080
   
8. 2023-09-05 00:01:09 30215 [Note] InnoDB: 128 rollback segment(s) are active.
   
9. 2023-09-05 00:01:09 30215 [Note] InnoDB: Waiting for purge to start
   
10. 2023-09-05 00:01:09 30215 [Note] InnoDB: 5.6.51 started; log sequence number 987742792

复制代码

在网上搜索教程，修改my.cnf文件，在my.cnf中的[mysqld]中添加：
innodb_force_recovery = 6
innodb_purge_threads = 1
重启Mysql之后发现文章页面打开不了。首页可以打开。这个方法试了不行。不知道怎么去解决了。求解决方法

---

作者: licess    时间: 2023-9-5 16:22
innodb_force_recovery的值从1到6挨个试试看看它自己能修复不，innodb_purge_threads参数别加

---

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)

Powered by Discuz! X3.4