Optimization Series | MySQL 5.6.10 vs Percona 5.6.6 TPCCC Performance Test

MySQL official 5.6. The 10 version came out, claiming that compared to the previous version of the performance improved a lot, the actual test, indeed improved, but compared to the Percona 5.6.6 in terms of performance has no advantage.

1. TPCC Test Results
650) this.width=650; "title=" MySQL 5.6.10 vs Percona 5.6.6 TPCCC Performance test Result "src=" Http://dp.imysql.com:8080/files/upload_ Yejr_imysql/mysql_5.6.10_vs_percona_5.6.6_tpcc_oltp_benchmarking_20130221.png "style=" border:0px; "alt=" MySQL_ 5.6.10_vs_percona_5.6.6_tpcc_oltp_ "/>
Click to view larger image

2. Test environment
650) this.width=650; "title=" MySQL 5.6.10 vs Percona 5.6.6 TPCCC Performance Test-test environment "src=" http://dp.imysql.com:8080/files/ Upload_yejr_imysql/mysql_5.6.10_vs_percona_5.6.6_tpcc_oltp_benchmarking_env_20130221.png "style=" border:0px; " alt= "Mysql_5.6.10_vs_percona_5.6.6_tpcc_oltp_"/>

3. InnoDB Key configuration options
650) this.width=650; "title=" MySQL 5.6.10 vs Percona 5.6.6 TPCCC Performance Test-innodb key configuration Options "Src=" http://dp.imysql.com:8080/ Files/upload_yejr_imysql/mysql_5.6.10_vs_percona_5.6.6_tpcc_oltp_benchmarking_var_20130221.png "style=" border:0 px; "alt=" Mysql_5.6.10_vs_percona_5.6.6_tpcc_oltp_ "/>

Note:
1,ring replication: Refers to 3 nodes to build a circular copy, respectively, are master/slave. In the test process, also try to simulate master down, slave arbitrary switch Master, verify the data reliability in Gtid mode, in the test mode, it does guarantee the data reliability.
2.bp8_facts: Set innodb_buffer_pool_instances = 8 and metadata_locks_hash_instances = The default configuration is innodb_buffer_pool_instances = 1.
3,Nobinlog: Refers to the mode of closing Binlog.

Personal point of view: The official version of the more and more good, Percona branch in addition to the ease of use to continue to maintain the advantages, performance improvements in the advantages of smaller and weaker, the subsequent weakness. If this is the case, then you can consider switching to the official version of the main line.

--------------------------------------Split Line--------------------------------------

http://zhishuedu.comTraining is a professional quality training brand jointly launched by senior MySQL expert Ye Jinlong and Wu Bingxi, with MySQL dba combat optimization and Python devops Development course, which is the most conscientious and The most quality training courses.

This article is from the "Lao Ye teahouse" blog, please be sure to keep this source http://imysql.blog.51cto.com/1540006/1879768

Optimization Series | MySQL 5.6.10 vs Percona 5.6.6 TPCCC Performance Test