5.数据库优化

------------------------
数据库优化
------------------------

依自己的云主机内存大小，做出相应的内存选择，宝塔面板将自动调整底下的数据

例如 我用2GB内存的云主机

宝塔面板 -> 软件商店 -> 已安装 -> MySQL 8.0 -> 设置 -> 性能调整 -> 优化方案 -> 2-4GB

-> 保存 -> 重启数据库

--------------------------------
宝塔面板给的数据库优化设置
--------------------------------

优化方案 2 - 4 GB
key_buffer_size = 256M
table_open_cache = 192
sort_buffer_size = 768K
read_buffer_size = 768K
read_rnd_buffer_size = 512K
thread_cache_size = 96
query_cache_size = 128M
tmp_table_size = 384M
max_connections = 200
innodb_buffer_pool_size = 384M
innodb_log_buffer_size = 16M

join_buffer_size = 2048K
thread_stack = 256K
binlog_cache_size = 64K

优化方案 4 - 8 GB
key_buffer_size = 384M
table_open_cache = 384
sort_buffer_size = 1024K
read_buffer_size = 1024K
read_rnd_buffer_size = 768K
thread_cache_size = 128
query_cache_size = 192M
tmp_table_size = 512M
max_connections = 300
innodb_buffer_pool_size = 512M
innodb_log_buffer_size = 16M

join_buffer_size = 2048K
thread_stack = 256K
binlog_cache_size = 128K