MySQL 5.6 my.cnf配置优化
4核 16G Centos6.5 x64
优化后测试结果如下
#mysqlslap
#--concurrency=2
#--iterations=1
#--number-int-cols=10
#--number-char-cols=10
#-a
#--auto-generate-sql-guid-primary
#--auto-generate-sql-secondary-indexes=2
#--number-of-queries=10000
#--auto-generate-sql-load-type=write
#--engine=myisam,innodb -uroot -proot --debug-info
结果:
Benchmark
# Running for engine myisam
# Average number of seconds to run all queries: 1.064 seconds
# Minimum number of seconds to run all queries: 1.064 seconds
# Maximum number of seconds to run all queries: 1.064 seconds
# Number of clients running queries: 2
# Average number of queries per client: 5000
#
Benchmark
# Running for engine innodb
# Average number of seconds to run all queries: 2.650 seconds
# Minimum number of seconds to run all queries: 2.650 seconds
# Maximum number of seconds to run all queries: 2.650 seconds
# Number of clients running queries: 2
# Average number of queries per client: 5000
配置及说明:
# MySql读入缓冲区大小。对表进行顺序扫描的请求将分配一个读入缓冲区,MySql会为它分配一段内存缓冲区。read_buffer
_size变量控制这一缓冲区的大小。如果对表的顺序扫描请求非常频繁,并且你认为频繁扫描进行得太慢,可以通过增加该变量
值以及内存缓冲区大小提高其性能。和sort_buffer_size一样,该参数对应的分配内存也是每个连接独享。
本文转自flyingzf 51CTO博客,原文链接:http://blog.51cto.com/flyingzf/1835072,如需转载请自行联系原作者