轻量化配置
针对 50MB 极小 内存目标
sudo nano /etc/mysql/mariadb.conf.d/99-lightweight.cnf
[mysqld]
# 核心：关闭性能监控，立省约 40MB+
performance_schema = OFF
# 存储引擎：将缓冲池压到最低 (适用于轻量 PHP 项目)
innodb_buffer_pool_size = 16M
innodb_log_buffer_size = 2M
innodb_flush_log_at_trx_commit = 2
innodb_stats_on_metadata = OFF
# 连接与线程：降低堆栈消耗
max_connections = 15
thread_stack = 192K
thread_cache_size = 0
# 临时表与缓存：防止内存突发占用
tmp_table_size = 2M
max_heap_table_size = 2M
table_open_cache = 400
table_definition_cache = 400
# 日志：禁用不必要的日志
skip-log-bin
sudo systemctl restart mariadb
查看内存情况
ps aux | grep mariadbd | grep -v grep | awk '{print $6/1024 " MB"}'
作为个人博客使用及时不配置其内存占用也较低，实际上配置了之后内存占用并没有降低多少，全站负载500MB
