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

Source: Internet
Author: User
Tags percona

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.