【待反馈】Mysql调整性能后，无法启动服务
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：9.00
系统版本：
CentOS8.5
问题描述：
MySQL mariadb_8.0.36安装后，使用mysql管理-性能调整后，无法启动服务
相关截图（日志、错误）：
2024-07-25T02:10:15.327024Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:16.800653Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:16.800705Z 0 ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:16.800766Z 0 ＇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 ＇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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4312182024-07-25T02:10:16.812217Z 0 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 InnoDB initialization has started.2024-07-25T02:10:17.063664Z 1 InnoDB initialization has ended.2024-07-25T02:10:17.269793Z 0 CA certificate ca.pem is self signed.2024-07-25T02:10:17.269823Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:17.273929Z 0 unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:17.273994Z 0 Aborting2024-07-25T02:10:18.831443Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:20.340811Z 0 081] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:20.340882Z 0 ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:20.340960Z 0 ＇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 ＇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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4319782024-07-25T02:10:20.352879Z 0 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 InnoDB initialization has started.2024-07-25T02:10:20.586723Z 1 InnoDB initialization has ended.2024-07-25T02:10:20.788298Z 0 CA certificate ca.pem is self signed.2024-07-25T02:10:20.788328Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:20.792272Z 0 unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:20.792350Z 0 Aborting2024-07-25T02:10:22.351130Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:23.882009Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:23.882057Z 0 ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:23.882114Z 0 ＇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 ＇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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4327342024-07-25T02:10:23.893226Z 0 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 InnoDB initialization has started.2024-07-25T02:10:24.173712Z 1 InnoDB initialization has ended.2024-07-25T02:10:24.407866Z 0 CA certificate ca.pem is self signed.2024-07-25T02:10:24.407895Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:24.412049Z 0 unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:24.412129Z 0 Aborting2024-07-25T02:10:25.980116Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.2024-07-25T02:10:27.422177Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2024-07-25T02:10:27.422227Z 0 ＇binlog_format＇ is deprecated and will be removed in a future release.2024-07-25T02:10:27.422288Z 0 ＇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 ＇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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 4335072024-07-25T02:10:27.433461Z 0 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 InnoDB initialization has started.2024-07-25T02:10:27.708983Z 1 InnoDB initialization has ended.2024-07-25T02:10:27.918639Z 0 CA certificate ca.pem is self signed.2024-07-25T02:10:27.918669Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-07-25T02:10:27.922652Z 0 unknown variable ＇query_cache_type=1＇.2024-07-25T02:10:27.922718Z 0 Aborting2024-07-25T02:10:29.480478Z 0 /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内存，它有一个默认数据，原来的没问题。现在升级了面板后，才出现的这种情况 ...
您好，具体的需要查看机器资源，面板上只是一个推荐的，具体需要根据情况而定
页:
[1]