我在 VPS Debian 10 上运行了几周，一直遇到 MariaDB 崩溃问题。我在网上搜索了很多，但找不到任何解决方案。我试过这，这，这等等...但说真的我没有找到任何解决方案。
这是 MariaDB 错误日志。
2021-06-15 17:03:53 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2021-06-15 17:04:24 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2021-06-15 17:04:24 0 [ERROR] Plugin 'Aria' init function returned error.
2021-06-15 17:04:24 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2021-06-15 17:04:24 0 [Note] InnoDB: Using Linux native AIO
2021-06-15 17:04:24 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-15 17:04:24 0 [Note] InnoDB: Uses event mutexes
2021-06-15 17:04:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-15 17:04:24 0 [Note] InnoDB: Number of pools: 1
2021-06-15 17:04:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-15 17:04:24 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-15 17:04:24 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-15 17:04:24 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-15 17:04:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1138436566
2021-06-15 17:04:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-06-15 17:04:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-06-15 17:04:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-06-15 17:04:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-06-15 17:04:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-06-15 17:04:24 0 [Note] InnoDB: Waiting for purge to start
2021-06-15 17:04:24 0 [Note] InnoDB: 10.3.27 started; log sequence number 1138436575; transaction id 567401
2021-06-15 17:04:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-06-15 17:04:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-15 17:04:24 0 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2021-06-15 17:04:24 0 [ERROR] Aborting
这是我的 MariaDB 配置
[server]
[mysqld]
performance_schema = on
user = mysql
pid-file = /run/mysqld/mysqld.pid
socket = /run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
bind-address = 127.0.0.1
query_cache_size = 32M
log_error = /var/log/mysql/error.log
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
innodb_file_per_table = 1
thread_cache_size = 8
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
table_open_cache = 512
max_allowed_packet = 512M
key_buffer_size = 384M
[embedded]
[mariadb]
[mariadb-10.3]
服务器资源没有出现峰值。检查时这是使用情况统计数据。
0.44 (1 min) 0.27 (5 mins) 0.15 (15 mins)
出现此错误时，我会手动终止进程 ID 并重新启动服务器。这就是我现在处理这种情况的方法。我检查了 /var/lib/mysql 中是否存在任何文件夹权限问题，但没有问题，所有权是 mysql:mysql。
您可以检查完整的错误日志这里。
我非常感谢你的帮助。