今天我采用tpcc-mysql进行了基础的配置性能测试,主要对比了几组不同参数下的tpmc值:
1、
innodb_flush_log_at_trx_commit = 1
sync-binlog = 0
15333.000 TpmC
2、
innodb_flush_log_at_trx_commit = 1
sync-binlog = 1
13651.000 TpmC
3、
innodb_flush_log_at_trx_commit = 2
sync-binlog = 0
15163.000 TpmC
4、
innodb_flush_log_at_trx_commit = 2
sync-binlog = 1
14466.000 TpmC
//后续我回加入写性能的测试结果