MySQL 5.6 vs mariadb 5.5 vs percona (5.5 & 5.6) tpcc performance test

Turn from old leaves, original: http://imysql.com/2012/10/08/mysql-vs-mariadb-vs-percona-tpcc-testing.html

I. Brief Introduction
It is a free open-source database server developed by a company founded by Michael widenius, a MySQL author. Mariadb is a transaction-based Maria storage engine that replaces MySQL's MyISAM storage engine. It uses the xtradb and InnoDB variants of percona. This version also includes the primebase XT (pbxt) and federatedx storage engines. (From: http://baike.baidu.com/view/2521908.htm)
To put it simply, mariadb is a variant of MySQL. It can be used as a substitute for the official MySQL version and has been enhanced in some features.
Mariadb official website see: http://mariadb.org

Ii. Test Environment
2.1 For detailed test environment, see:

2.2 for examples of automated test scripts, see:

#! /Bin/sh # export LD_LIBRARY_PATH =/usr/local/MySQL/lib /.~ /. Bash_profile>/dev/null 2> & 1 basedir = "/home/tpcc-mysql" CD $ basedirmkdir-p $ basedir/logsexec 3> & 1 4> & 2 1> tpcc. log 2> & 1 # Database ipdbip = localhostdbuser = 'root' dbpass = ''for tpcc testing # Test Mode: wirehouse = 1000 dbname = "tpcc $ {wirehouse}" # data push time: 1000 seconds warmup = 120 # test duration: 1 hour during = 3600 # test mode = "duration" # initialize the test environment if [-z "'mysqlshow-h $ dbip-U $ dbuser-p $ dbpass | grep-V grep | grep \ "$ dbname \" '"]; then mysqladmin-h $ dbip-U $ dbuser-p $ dbpass-F create $ dbname mysql-h $ dbip-U $ dbuser-p $ dbpass-F $ dbname/proc/sys /Vm/drop_caches; /etc/init. d/MySQL start; sleep 60 # Start the tpcc test. /tpcc_start-h $ dbip-d $ dbname-U $ dbuser-P "$ {dbpass}"-W $ wirehouse-C $ threads-r $ warmup-L $ during-F. /logs/tpcc _ $ {mode }_$ {now }_$ {threads} _ threads _ $ {cycle }. res>. /logs/tpcc_runlog _ $ {mode }_$ {now }_$ {threads} _ threads _ $ {cycle} 2> & 1 donecycle = 'expr $ cycle + 1' done

2.3 comparison of key configuration options

Iii. Test Results
Note:

Exclusive refers to the use of independent tablespace mode; 1bp/8bp respectively refer to: Set InnoDB buffer pool instance to 1 or 8.

3.1 tpcc data initialization comparison

3.2 comparison of tpmc results

In this comparative test, under the pattern "percona 5.6.6-m9-56 (exclusive, 1 bp)" (yellow bottom), the Integrated tpmc has the highest efficiency. Therefore, tpmc efficiency in other test modes is compared directly with it.

Iv. Summary
This is only a simple benchmark test of tpmc. All the improvements and features announced by MySQL 5.6 and mariadb are not covered yet.
From the test results, the performance of percona 5.6 still has a great advantage. In addition, compared with previous versions, the more concurrent threads within a certain number of threads, the higher the efficiency of tpmc.