【已解答】MySQL自动关闭

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：

系统版本：

问题描述：MySQL自动关闭

相关截图（日志、错误）：慢日志

INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES (＇_site_transient_timeout_available_translations＇, ＇1696692801＇, ＇no＇) ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    13

# Query_time: 11.856022  Lock_time: 0.008987 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    29

# Query_time: 11.768527  Lock_time: 0.002226 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    17

# Query_time: 11.862322  Lock_time: 0.000770 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    28

# Query_time: 11.846029  Lock_time: 0.003881 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    30

# Query_time: 11.801315  Lock_time: 0.006243 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    12

# Query_time: 11.866728  Lock_time: 0.003532 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    16

# Query_time: 11.861766  Lock_time: 0.010794 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     4

# Query_time: 11.865738  Lock_time: 0.006954 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    24

# Query_time: 11.836791  Lock_time: 0.007713 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    31

# Query_time: 11.736367  Lock_time: 0.000101 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     6

# Query_time: 11.878758  Lock_time: 0.002403 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     1

# Query_time: 11.879949  Lock_time: 0.003263 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     2

# Query_time: 11.879011  Lock_time: 0.009062 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     3

# Query_time: 11.875058  Lock_time: 0.014759 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    10

# Query_time: 11.875034  Lock_time: 0.012321 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     5

# Query_time: 11.878994  Lock_time: 0.007170 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    26

# Query_time: 11.858246  Lock_time: 0.026866 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    25

# Query_time: 11.848316  Lock_time: 0.000352 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    27

# Query_time: 11.862743  Lock_time: 0.000053 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    22

# Query_time: 11.875408  Lock_time: 0.014798 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    21

# Query_time: 11.880753  Lock_time: 0.007065 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:    18

# Query_time: 11.887295  Lock_time: 0.006354 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

# User@Host: www_qiangdajixie[www_qiangdajixie] @ localhost []  Id:     7

# Query_time: 11.911245  Lock_time: 0.005726 Rows_sent: 366  Rows_examined: 366

SET timestamp=1696682010;

SELECT option_name, option_value FROM wp_options WHERE autoload = ＇yes＇;

/www/server/mysql/bin/mysqld, Version: 5.6.50-log (Source distribution). started with:

Tcp port: 3306  Unix socket: /tmp/mysql.sock

Time                 Id Command    Argument

/www/server/mysql/bin/mysqld, Version: 5.6.50-log (Source distribution). started with:

Tcp port: 3306  Unix socket: /tmp/mysql.sock

Time                 Id Command    Argument

您好，根据您提供的慢日志信息，慢查询较多，慢查询会增加mysql和系统资源的负载，如果系统资源满载了，就会导致mysql服务没有足够的资源运行，然后mysql就会自动关闭了。建议您根据这些慢日志信息来进行索引优化。