Mysql 最小化资源配置
小内存 vps 很多，有时我们只是用来安装一个博客而已，但是 MySQL 默认的配置比较迟资源
| Setting | Default | Minimum |
|---|---|---|
| innodb_buffer_pool_size | 128M | 5M |
| innodb_log_buffer_size | 1M | 0 |
| query_cache_sizequery_cache_size | 1M | 0 |
| max_connections | 151 | 1(although 10 might be more reasonable) |
| key_buffer_size | 8388608 | 8 |
| thread_cache_size | (autosized) | 0 |
| host_cache_size | (autosized) | 0 |
| innodb_ft_cache_size | 8000000 | 1600000 |
| innodb_ft_total_cache_size | 640000000 | 32000000 |
| thread_stack | 262144 | 131072 |
| sort_buffer_size | 262144 | 32K |
| read_buffer_size | 131072 | 8200 |
| read_rnd_buffer_size | 262144 | 8200 |
| max_heap_table_size | 16777216 | 16K |
| tmp_table_size | 16777216 | 1K |
| bulk_insert_buffer_size | 8388608 | 0 |
| join_buffer_size | 262144 | 128 |
| net_buffer_length | 16384 | 1K |
| innodb_sort_buffer_size | 1M | 64K |
| binlog_cache_size | 32K | 4K |
| binlog_stmt_cache_size | 32K | 4K |
你当然可以通过禁用 InnoDB 来节省内存，但一般不建议这么做，除非你的内存小到了极致。
如此，我们针对便宜的小内存 vps 的 my.cnf 应该是如下：
# /etc/my.cnf:
innodb_buffer_pool_size=5M
innodb_log_buffer_size=256K
query_cache_size=0
max_connections=10
key_buffer_size=8
thread_cache_size=0
host_cache_size=0
innodb_ft_cache_size=1600000
innodb_ft_total_cache_size=32000000
# per thread or per operation settings
thread_stack=131072
sort_buffer_size=32K
read_buffer_size=8200
read_rnd_buffer_size=8200
max_heap_table_size=16K
tmp_table_size=1K
bulk_insert_buffer_size=0
join_buffer_size=128
net_buffer_length=1K
innodb_sort_buffer_size=64K
#settings that relate to the binary log (if enabled)
binlog_cache_size=4K
binlog_stmt_cache_size=4K