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

【待反馈】mysql自动停止

发表在 Linux面板2024-8-24 09:41 [复制链接] 4 450

为了能快速了解并处理您的问题,请提供以下基础信息:
面板、插件版本:9.1.0
系统版本:centos7.9 服务器配置4-8 mysql版本:8.0.24
问题描述:自动关闭且数据库的数据也被删除
相关截图(日志、错误):
2024-08-24T01:16:59.374996Z 3140 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.24).
2024-08-24T01:17:01.378240Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3080  user: 'angelgiftcard'.
2024-08-24T01:17:01.378339Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3072  user: 'angelgiftcard'.
2024-08-24T01:17:01.378410Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2888  user: 'angelgiftcard'.
2024-08-24T01:17:01.378467Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3081  user: 'angelgiftcard'.
2024-08-24T01:17:01.378556Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2905  user: 'angelgiftcard'.
2024-08-24T01:17:01.378622Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2538  user: 'root'.
2024-08-24T01:17:01.378727Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3090  user: 'angelgiftcard'.
2024-08-24T01:17:01.378799Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2906  user: 'angelgiftcard'.
2024-08-24T01:17:01.378849Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3091  user: 'angelgiftcard'.
2024-08-24T01:17:01.378894Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2539  user: 'root'.
2024-08-24T01:17:01.378991Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2899  user: 'angelgiftcard'.
2024-08-24T01:17:01.379041Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2932  user: 'angelgiftcard'.
2024-08-24T01:17:01.379140Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2908  user: 'angelgiftcard'.
2024-08-24T01:17:01.379182Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3069  user: 'angelgiftcard'.
2024-08-24T01:17:01.379238Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3070  user: 'angelgiftcard'.
2024-08-24T01:17:01.379278Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3078  user: 'angelgiftcard'.
2024-08-24T01:17:01.379333Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2894  user: 'angelgiftcard'.
2024-08-24T01:17:01.379378Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2374  user: 'root'.
2024-08-24T01:17:01.379416Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2886  user: 'angelgiftcard'.
2024-08-24T01:17:01.379449Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2550  user: 'root'.
2024-08-24T01:17:01.379492Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2887  user: 'angelgiftcard'.
2024-08-24T01:17:01.379528Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3079  user: 'angelgiftcard'.
2024-08-24T01:17:01.379604Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2375  user: 'root'.
2024-08-24T01:17:01.379668Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 2895  user: 'angelgiftcard'.
2024-08-24T01:17:01.379730Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3071  user: 'angelgiftcard'.
2024-08-24T01:17:02.250647Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.

使用道具 举报 只看该作者 回复
发表于 2024-8-24 10:22:10 | 显示全部楼层
这段日志是正常的shut down关闭,你这个信息不够
使用道具 举报 回复 支持 反对
发表于 2024-8-24 10:49:43 | 显示全部楼层
但是数据库宕机前的错误日志就这些,再次启动数据库的数据就没了
使用道具 举报 回复 支持 反对
发表于 2024-8-24 21:13:04 | 显示全部楼层
mysql数据库需要优化一下。
使用道具 举报 回复 支持 反对
发表于 2024-8-26 11:01:40 | 显示全部楼层
您好,建议排查一下您服务器所使用的数据容量有多少,优化mysql
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

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

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

紧急运维服务

响应时间:3分钟

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

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

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

立即付费处理

工作时间:09:00至24:00

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