Hello, I am currently using aaPanel version 6.8.36. Occasionally, all of my sites consume 100% of system resources, which results in MySQL server downtimes. Additionally, MySQL does not restart automatically. Although these downtimes only last about a minute or so each month, they are disruptive. How can I resolve this issue to ensure that the MySQL server restarts automatically?
this is my error log.
2024-04-13T14:16:33.276665Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-04-13T14:16:33.278283Z 0 [Warning] '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-04-13T14:16:33.278294Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-04-13T14:16:33.278333Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-04-13T14:16:33.278892Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.43-log) starting as process 3151085 ...
2024-04-13T14:16:33.392045Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-04-13T14:16:33.392103Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-13T14:16:33.392108Z 0 [Note] InnoDB: Uses event mutexes
2024-04-13T14:16:33.392112Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-13T14:16:33.392116Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-04-13T14:16:33.394370Z 0 [Note] InnoDB: Number of pools: 1
2024-04-13T14:16:33.397588Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-04-13T14:16:33.403409Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2024-04-13T14:16:34.373328Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-13T14:16:34.515536Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-04-13T14:16:34.533113Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-04-13T14:16:34.572975Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 4559963594
2024-04-13T14:16:34.573067Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4559963603
2024-04-13T14:16:34.573143Z 0 [Note] InnoDB: Database was not shutdown normally!
2024-04-13T14:16:34.573151Z 0 [Note] InnoDB: Starting crash recovery.
2024-04-13T14:16:34.686493Z 0 [Note] InnoDB: Last MySQL binlog file position 0 216310496, file name mysql-bin.000022
2024-04-13T14:16:35.050299Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-13T14:16:35.050412Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-13T14:16:35.050484Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-13T14:16:35.068436Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-04-13T14:16:35.069525Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2024-04-13T14:16:35.069561Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2024-04-13T14:16:35.070125Z 0 [Note] InnoDB: Waiting for purge to start
2024-04-13T14:16:35.120503Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 4559963603
2024-04-13T14:16:35.120862Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-04-13T14:16:35.121752Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-04-13T14:16:35.126149Z 0 [Note] Recovering after a crash using mysql-bin
2024-04-13T14:16:35.287533Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240413 10:16:35
2024-04-13T14:16:35.726746Z 0 [Note] Starting crash recovery...
2024-04-13T14:16:35.726911Z 0 [Note] Crash recovery finished.
2024-04-13T14:16:35.994144Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2024-04-13T14:16:35.994434Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2024-04-13T14:16:35.994446Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2024-04-13T14:16:35.994450Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2024-04-13T14:16:35.995542Z 0 [Warning] CA certificate ca.pem is self signed.
2024-04-13T14:16:35.995833Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-04-13T14:16:35.996279Z 0 [Note] Server hostname (bind-address): ''; port: 3306
2024-04-13T14:16:35.996320Z 0 [Note] IPv6 is available.
2024-04-13T14:16:35.996325Z 0 [Note] - '::' resolves to '::';
2024-04-13T14:16:35.996559Z 0 [Note] Server socket created on IP: '::'.
2024-04-13T14:16:36.010932Z 0 [Note] Failed to start slave threads for channel ''
2024-04-13T14:16:36.031486Z 0 [Note] Event Scheduler: Loaded 0 events
2024-04-13T14:16:36.031811Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.43-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-04-13T14:16:59.825664Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-04-13T14:16:59.826957Z 0 [Warning] '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-04-13T14:16:59.826974Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-04-13T14:16:59.827026Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-04-13T14:16:59.827351Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.43-log) starting as process 3151211 ...
2024-04-13T14:16:59.895427Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-04-13T14:16:59.895506Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-13T14:16:59.895512Z 0 [Note] InnoDB: Uses event mutexes
2024-04-13T14:16:59.895518Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-13T14:16:59.895521Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-04-13T14:16:59.897704Z 0 [Note] InnoDB: Number of pools: 1
2024-04-13T14:16:59.900668Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-04-13T14:16:59.903870Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2024-04-13T14:17:00.534993Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-13T17:30:57.247816Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-04-13T17:30:57.256475Z 0 [Warning] '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-04-13T17:30:57.256516Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-04-13T17:30:57.256572Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-04-13T17:30:57.258685Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.43-log) starting as process 3156133 ...
2024-04-13T17:30:57.402407Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-04-13T17:30:57.402497Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-13T17:30:57.402503Z 0 [Note] InnoDB: Uses event mutexes
2024-04-13T17:30:57.402507Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-13T17:30:57.402511Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-04-13T17:30:57.406028Z 0 [Note] InnoDB: Number of pools: 1
2024-04-13T17:30:57.413502Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-04-13T17:30:57.422078Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2024-04-13T17:30:58.174379Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-13T17:30:58.413630Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-04-13T17:30:58.443311Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-04-13T17:30:58.522886Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 4559963631
2024-04-13T17:30:58.522946Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4559963640
2024-04-13T17:30:58.522953Z 0 [Note] InnoDB: Database was not shutdown normally!
2024-04-13T17:30:58.522958Z 0 [Note] InnoDB: Starting crash recovery.
2024-04-13T17:30:58.713572Z 0 [Note] InnoDB: Last MySQL binlog file position 0 216310496, file name mysql-bin.000022
2024-04-13T17:30:59.060431Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-13T17:30:59.060461Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-13T17:30:59.060529Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-13T17:30:59.086817Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-04-13T17:30:59.087526Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2024-04-13T17:30:59.087537Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2024-04-13T17:30:59.087981Z 0 [Note] InnoDB: Waiting for purge to start
2024-04-13T17:30:59.138529Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 4559963640
2024-04-13T17:30:59.139153Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-04-13T17:30:59.140102Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-04-13T17:30:59.152293Z 0 [Note] Recovering after a crash using mysql-bin
2024-04-13T17:30:59.152645Z 0 [Note] Starting crash recovery...
2024-04-13T17:30:59.152740Z 0 [Note] Crash recovery finished.
2024-04-13T17:30:59.169942Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2024-04-13T17:30:59.169980Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2024-04-13T17:30:59.169992Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2024-04-13T17:30:59.169996Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2024-04-13T17:30:59.171000Z 0 [Warning] CA certificate ca.pem is self signed.
2024-04-13T17:30:59.171511Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-04-13T17:30:59.171978Z 0 [Note] Server hostname (bind-address): ''; port: 3306
2024-04-13T17:30:59.172026Z 0 [Note] IPv6 is available.
2024-04-13T17:30:59.172033Z 0 [Note] - '::' resolves to '::';
2024-04-13T17:30:59.172058Z 0 [Note] Server socket created on IP: '::'.
2024-04-13T17:30:59.184434Z 0 [Note] Failed to start slave threads for channel ''
2024-04-13T17:30:59.214725Z 0 [Note] Event Scheduler: Loaded 0 events
2024-04-13T17:30:59.215140Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.43-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-04-13T17:31:00.298604Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240413 13:31:00