DB MYsql Always Crash and shotdown
mysqlversion 8.0.35
Error LOG
2024-11-29T06:14:50.403543Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-11-29T06:15:35.018939Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2024-11-29T06:15:35.019876Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-11-29T06:15:35.020504Z 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-11-29T06:15:35.021578Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 379567
2024-11-29T06:15:35.563346Z 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=10485760. Please use innodb_redo_log_capacity instead.
2024-11-29T06:15:35.702700Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-29T06:15:38.210927Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-29T06:16:46.881913Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2024-11-29T06:16:46.883126Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-11-29T06:16:46.885995Z 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-11-29T06:16:46.889579Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 379631
2024-11-29T06:16:47.431391Z 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=10485760. Please use innodb_redo_log_capacity instead.
2024-11-29T06:16:47.499130Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-29T06:16:48.372131Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-29T14:56:38.780867Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2024-11-29T14:56:38.781891Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-11-29T14:56:38.783222Z 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-11-29T14:56:38.785375Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 388127
2024-11-29T14:56:38.951501Z 0 [ERROR] [MY-000058] [Server] Unknown suffix 'd' used for variable 'innodb-buffer-pool-size' (value 'detected server memory * 0.5').
2024-11-29T14:56:38.951543Z 0 [Warning] [MY-000080] [Server] option 'innodb-buffer-pool-size': signed value 0 adjusted to 5242880.
2024-11-29T14:56:38.951550Z 0 [ERROR] [MY-000077] [Server] /www/server/mysql/bin/mysqld: Error while setting value 'detected server memory * 0.5' to 'innodb-buffer-pool-size'.
2024-11-29T14:56:38.951558Z 0 [ERROR] [MY-010746] [Server] Parsing options for plugin 'InnoDB' failed.
2024-11-29T14:56:38.951585Z 0 [ERROR] [MY-010168] [Server] Failed to initialize builtin plugins.
2024-11-29T14:56:38.951595Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-11-29T14:56:38.959287Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.35) Source distribution.
2024-11-29T14:57:08.762669Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2024-11-29T14:57:08.762780Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-11-29T14:57:08.762882Z 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-11-29T14:57:08.763107Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 388841
2024-11-29T14:57:08.918005Z 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=10485760. Please use innodb_redo_log_capacity instead.
2024-11-29T14:57:08.931801Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-29T14:57:09.781212Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-29T14:57:10.453013Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2024-11-29T14:57:10.497489Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
mysqld: File './mysql-bin.000006' not found (OS errno 2 - No such file or directory)
2024-11-29T14:57:10.583609Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2024-11-29T14:57:10.627705Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-11-29T14:57:10.627782Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-11-29T14:57:10.692442Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-11-29T14:57:10.693001Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
==
slow log
Time: 2024-11-29T06:01:03.667631Z
User@Host: wpkayishop[wpkayishop] @ [45.32.104.71] Id: 2443
Query_time: 3.026493 Lock_time: 0.006977 Rows_sent: 176 Rows_examined: 208
use wpkayishop;
SET timestamp=1732860060;
SELECT option_name, option_value FROM wp_c027d29f11_options WHERE autoload IN ( 'yes', 'on', 'auto-on', 'auto' );
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
