mysql 基准测试-01

最新推荐文章于 2023-09-30 17:22:31 发布

大海的水

最新推荐文章于 2023-09-30 17:22:31 发布

阅读量238

点赞数

分类专栏： mysql 文章标签： mysql percona5.6 基准压测 tpcc-mysql 性能

本文链接：https://blog.csdn.net/c446591512/article/details/77898827

版权

mysql 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

1、稳定性测试对比组

percona 5.6.36VSmysql 5.5.47

同样设置下，运行基准测试，对比各自稳定性

2、不能参数设置，性能对比组

第一组修改参数
sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 8M

transaction-isolation = REPEATABLE-READ

innodb_io_capacity=200

innodb_flush_method =默认设置

innodb_log_buffer_size=8M

innodb_additional_mem_pool_size= 默认设置

第二组参数

sort_buffer_size = 4M
join_buffer_size = 1M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 8M
transaction-isolation = REPEATABLE-READ
innodb_io_capacity=2000
innodb_flush_method = O_DSYNC/O_DIRECT
innodb_log_buffer_size=8M
innodb_additional_mem_pool_size=2M

3、性能优化效果

一组

sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 8M