My MySQL 10.5.6-MariaDB stops occasionally. Makes the website database database faulty completely. Needing to restart manually MySQL 10.5.6-MariaDB.
AAPanel: 6.8.13
System: CentOS 8.4.2105(Py3.7.9)
Log stop time:
2021-07-16 19:36:44 0 [Note] InnoDB: Using Linux native AIO
2021-07-16 19:36:44 0 [Note] InnoDB: Uses event mutexes
2021-07-16 19:36:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-16 19:36:44 0 [Note] InnoDB: Number of pools: 1
2021-07-16 19:36:44 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
2021-07-16 19:36:44 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-07-16 19:36:44 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2021-07-16 19:36:44 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-16 19:36:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-16 19:36:44 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6857824410
2021-07-16 19:36:44 0 [Note] InnoDB: Last binlog file './mysql-bin.000007', position 526887041
2021-07-16 19:36:44 0 [Note] InnoDB: 128 rollback segments are active.
2021-07-16 19:36:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-16 19:36:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-16 19:36:44 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-16 19:36:44 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2021-07-16 19:36:44 0 [Note] InnoDB: 10.5.6 started; log sequence number 6857824422; transaction id 1231100
2021-07-16 19:36:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-16 19:36:44 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2021-07-16 19:36:44 0 [Note] Recovering after a crash using mysql-bin
Log restart manually:
2021-07-16 20:24:02 0 [Note] InnoDB: Using Linux native AIO
2021-07-16 20:24:02 0 [Note] InnoDB: Uses event mutexes
2021-07-16 20:24:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-16 20:24:02 0 [Note] InnoDB: Number of pools: 1
2021-07-16 20:24:02 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
2021-07-16 20:24:02 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-07-16 20:24:02 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2021-07-16 20:24:02 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-16 20:24:02 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-16 20:24:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6857824434
2021-07-16 20:24:02 0 [Note] InnoDB: Last binlog file './mysql-bin.000007', position 526887041
2021-07-16 20:24:02 0 [Note] InnoDB: 128 rollback segments are active.
2021-07-16 20:24:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-16 20:24:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-16 20:24:02 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-16 20:24:02 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2021-07-16 20:24:02 0 [Note] InnoDB: 10.5.6 started; log sequence number 6857824446; transaction id 1231100
2021-07-16 20:24:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-16 20:24:02 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2021-07-16 20:24:02 0 [Note] Recovering after a crash using mysql-bin
2021-07-16 20:24:03 0 [Note] InnoDB: Buffer pool(s) load completed at 210716 20:24:03
2021-07-16 20:24:03 0 [Note] Starting crash recovery...
2021-07-16 20:24:03 0 [Note] Crash recovery finished.
2021-07-16 20:24:03 0 [Note] Server socket created on IP: '::'.
2021-07-16 20:24:03 0 [Note] Reading of all Master_info entries succeeded
2021-07-16 20:24:03 0 [Note] Added new Master_info '' to hash table
2021-07-16 20:24:03 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.5.6-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2021-07-16 20:24:04 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Thanks!