MySQL5.6.10vsPercona5.6.6 TPCCC performance test

After MySQL version 5.6.10 was released, it said that the performance was much better than the previous version. The actual test has indeed improved, but it still has no performance advantage over Percona5.6.6. 1. Click to view the tpcc test results. The test environment is large. 3. Note the key configuration options of InnoDB: 1. ringreplication: three nodes build a ring.

After MySQL version 5.6.10 was released, it is said that it has improved the performance much better than the previous version. The actual test has indeed improved, but it still has no performance advantage over Percona 5.6.6. 1. Click to view the tpcc test result. 2. test environment. 3. Key configuration options of InnoDB. Remarks: 1. ring replication: three nodes build a ring.

After MySQL version 5.6.10 was released, it is said that it has improved the performance much better than the previous version. The actual test has indeed improved, but it still has no performance advantage over Percona 5.6.6.

1. tpcc test results

Click to view the chart

2. Test Environment

3. Key configuration options of InnoDB

Note:
1,Ring replication: The three nodes are respectively master nodes and slave nodes. During the test, we also tried to simulate master downtime, and slave switched the master randomly to verify the data reliability in GTID mode. In the test mode, the data reliability was indeed guaranteed.
2,Bp8_facts: SetInnodb_buffer_pool_instances = 8AndMetadata_locks_hash_instances = 256The default configuration isInnodb_buffer_pool_instances = 1.
3,Nobinlog: Indicates the binlog disabling mode.

My opinion: the official version is getting better and better. In addition to maintaining the advantage in ease of use, the Percona branch is getting weaker and weaker in terms of performance improvement. If this is the case, you can switch to the official version.

Technical issues:

InnoDB

Replication/synchronization

O & M

Original article address: MySQL 5.6.10 vs Percona 5.6.6 TPCCC performance test. Thank you for sharing it with me.