记一次mysql Innodb高并发读写的优化设置
kevin.Zhu 发布于：2021-4-14 10:26 分类：文摘 有 17 人浏览，获得评论 0 条
在aws上主要优化的参数如下：
bulk_insert_buffer_size 67108864
innodb_buffer_pool_instances 8
innodb_buffer_pool_size {DBInstanceClassMemory*3/4}
innodb_change_buffering all
innodb_change_buffer_max_size 50
innodb_file_per_table 1
innodb_flush_log_at_trx_commit 0
innodb_log_buffer_size 8388608
innodb_log_file_size 268435456
innodb_purge_threads 4
key_buffer_size 16777216
query_cache_type 1
query_cache_limit 134217728
read_buffer_size 262144
read_rnd_buffer_size 524288
table_open_cache 100000
table_open_cache_instances 16
thread_cache_size 128