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,如需转载请自行联系原作者