kkkkun 发表于 2024-8-24 09:41:39

【待反馈】mysql自动停止

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

爪洼 发表于 2024-8-24 10:22:10

这段日志是正常的shut down关闭,你这个信息不够

kkkkun 发表于 2024-8-24 10:49:43

但是数据库宕机前的错误日志就这些,再次启动数据库的数据就没了

大饼爱小饼 发表于 2024-8-24 21:13:04

mysql数据库需要优化一下。

运维技术阿闯 发表于 2024-8-26 11:01:40

您好,建议排查一下您服务器所使用的数据容量有多少,优化mysql
页: [1]
查看完整版本: 【待反馈】mysql自动停止