当前位置:论坛首页 > Linux面板 > 求助

【待反馈】mysql经常会自动关闭是哪里问题

发表在 Linux面板2022-12-30 09:53 [复制链接] 1 3454

  1. 2022-12-28 20:00:11 291506 [Note] InnoDB: Highest supported file format is Barracuda.
  2. 2022-12-28 20:00:11 291506 [Note] InnoDB: The log sequence numbers 1626024 and 1626024 in ibdata files do not match the log sequence number 337390686 in the ib_logfiles!
  3. 2022-12-28 20:00:11 291506 [Note] InnoDB: Database was not shutdown normally!
  4. 2022-12-28 20:00:11 291506 [Note] InnoDB: Starting crash recovery.
  5. 2022-12-28 20:00:11 291506 [Note] InnoDB: Reading tablespace information from the .ibd files...
  6. 2022-12-28 20:00:11 291506 [Note] InnoDB: Restoring possible half-written data pages
  7. 2022-12-28 20:00:11 291506 [Note] InnoDB: from the doublewrite buffer...
  8. InnoDB: Last MySQL binlog file position 0 34736708, file name mysql-bin.000008
  9. 2022-12-28 20:00:11 291506 [Note] InnoDB: 128 rollback segment(s) are active.
  10. 2022-12-28 20:00:11 291506 [Note] InnoDB: Waiting for purge to start
  11. 2022-12-28 20:00:11 291506 [Note] InnoDB: 5.6.50 started; log sequence number 337390686
  12. 2022-12-28 20:00:11 291506 [Note] Recovering after a crash using mysql-bin
  13. 2022-12-28 20:00:11 291506 [Note] Starting crash recovery...
  14. 2022-12-28 20:00:11 291506 [Note] Crash recovery finished.
  15. 2022-12-28 20:00:11 291506 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
  16. 2022-12-28 20:00:11 291506 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
  17. 2022-12-28 20:00:11 291506 [Note] Server hostname (bind-address): '*'; port: 3306
  18. 2022-12-28 20:00:11 291506 [Note] IPv6 is available.
  19. 2022-12-28 20:00:11 291506 [Note]   - '::' resolves to '::';
  20. 2022-12-28 20:00:11 291506 [Note] Server socket created on IP: '::'.
  21. 2022-12-28 20:00:11 291506 [Note] Event Scheduler: Loaded 0 events
  22. 2022-12-28 20:00:11 291506 [Note] /www/server/mysql/bin/mysqld: ready for connections.
  23. Version: '5.6.50-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
复制代码
这是mysql的部分日志文件,能不能看出问题出现的原因?
使用道具 举报 只看该作者 回复
发表于 2022-12-30 10:01:45 | 显示全部楼层
您好,您的服务器配置是什么的?检查系统日志是否被系统关闭了?
  1. dmesg|grep -E "kill|nginx|mysql|oom"
复制代码
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表