【待反馈】Mysql调整性能后，无法启动服务

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

面板、插件版本：

9.00

系统版本：

CentOS8.5

问题描述：

MySQL mariadb_8.0.36安装后，使用mysql管理-性能调整后，无法启动服务

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

2024-07-25T02:10:15.327024Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:16.800653Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:16.800705Z 0 [Warning] [MY-011070] [Server] ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:16.800766Z 0 [Warning] [MY-010915] [Server] ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2024-07-25T02:10:16.800847Z 0 [Warning] [MY-010918] [Server] ＇default_authentication_plugin＇ is deprecated and will be removed in a future release. Please use authentication_policy instead.2024-07-25T02:10:16.800879Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4312182024-07-25T02:10:16.812217Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.2024-07-25T02:10:16.814049Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2024-07-25T02:10:17.063664Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2024-07-25T02:10:17.269793Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.2024-07-25T02:10:17.269823Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:17.273929Z 0 [ERROR] [MY-000067] [Server] unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:17.273994Z 0 [ERROR] [MY-010119] [Server] Aborting2024-07-25T02:10:18.831443Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:20.340811Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:20.340882Z 0 [Warning] [MY-011070] [Server] ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:20.340960Z 0 [Warning] [MY-010915] [Server] ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2024-07-25T02:10:20.341056Z 0 [Warning] [MY-010918] [Server] ＇default_authentication_plugin＇ is deprecated and will be removed in a future release. Please use authentication_policy instead.2024-07-25T02:10:20.341089Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4319782024-07-25T02:10:20.352879Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.2024-07-25T02:10:20.354666Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2024-07-25T02:10:20.586723Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2024-07-25T02:10:20.788298Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.2024-07-25T02:10:20.788328Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:20.792272Z 0 [ERROR] [MY-000067] [Server] unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:20.792350Z 0 [ERROR] [MY-010119] [Server] Aborting2024-07-25T02:10:22.351130Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:23.882009Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:23.882057Z 0 [Warning] [MY-011070] [Server] ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:23.882114Z 0 [Warning] [MY-010915] [Server] ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2024-07-25T02:10:23.882196Z 0 [Warning] [MY-010918] [Server] ＇default_authentication_plugin＇ is deprecated and will be removed in a future release. Please use authentication_policy instead.2024-07-25T02:10:23.882227Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4327342024-07-25T02:10:23.893226Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.2024-07-25T02:10:23.895025Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2024-07-25T02:10:24.173712Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2024-07-25T02:10:24.407866Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.2024-07-25T02:10:24.407895Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:24.412049Z 0 [ERROR] [MY-000067] [Server] unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:24.412129Z 0 [ERROR] [MY-010119] [Server] Aborting2024-07-25T02:10:25.980116Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:27.422177Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:27.422227Z 0 [Warning] [MY-011070] [Server] ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:27.422288Z 0 [Warning] [MY-010915] [Server] ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2024-07-25T02:10:27.422387Z 0 [Warning] [MY-010918] [Server] ＇default_authentication_plugin＇ is deprecated and will be removed in a future release. Please use authentication_policy instead.2024-07-25T02:10:27.422418Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4335072024-07-25T02:10:27.433461Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.2024-07-25T02:10:27.435289Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2024-07-25T02:10:27.708983Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2024-07-25T02:10:27.918639Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.2024-07-25T02:10:27.918669Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:27.922652Z 0 [ERROR] [MY-000067] [Server] unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:27.922718Z 0 [ERROR] [MY-010119] [Server] Aborting2024-07-25T02:10:29.480478Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.

您好，根据您提供的日志信息，MySQL服务器在启动过程中遇到了一些问题。以下是一些关键错误和警告的摘要：

1：max_allowed_packet 参数的值过大，已被调整为 1073741824。
2：binlog_format 已被弃用，将在将来的版本中移除。
3：NO_ZERO_DATE, NO_ZERO_IN_DATE 和 ERROR_FOR_DIVISION_BY_ZERO SQL模式建议与严格模式一起使用。
4：default_authentication_plugin 已被弃用，请改用 authentication_policy。
5：query_cache_type=1 是一个未知变量。
6：CA证书 ca.pem 是自签名的。
7：TLS支持已配置，但存在加密连接问题

您这边先改回来您原来的配置吧

这是通过面板性能调整后出现的，那是不是性能调整就不能用了。

晗诺老豆 发表于 2024-7-25 11:41
这是通过面板性能调整后出现的，那是不是性能调整就不能用了。

您好，不是的，看信息是您调整的参数都是不合理导致的

运维技术阿闯 发表于 2024-7-25 11:47
您好，不是的，看信息是您调整的参数都是不合理导致的

使用性能调整，选择了4-8G内存，它有一个默认数据，原来的没问题。现在升级了面板后，才出现的这种情况

晗诺老豆 发表于 2024-7-25 12:00
使用性能调整，选择了4-8G内存，它有一个默认数据，原来的没问题。现在升级了面板后，才出现的这种情况 ...

您好，具体的需要查看机器资源，面板上只是一个推荐的，具体需要根据情况而定