Optimization Series | 5.5 Performance test for MySQL 5.6 vs MariaDB 5.5 vs Percona (TPCC & 5.6)

First, brief
is a free open source database server developed by a company founded by the original MySQL author Michael Widenius. MARIADB, the transaction-based Maria Storage engine, replaces the MySQL MyISAM storage engine, which uses the variant of the Percona Xtradb,innodb. This version also includes the PrimeBase XT (PBXT) and Federatedx storage engines. (Excerpt from: http://baike.baidu.com/view/2521908.htm)
Simply put: MARIADB is a variant of MySQL that can be used as an alternative to the official MySQL version and has been enhanced in some features.
MARIADB's official website see: http://mariadb.org

Second, the test environment
2.1 Detailed test environment see:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/MariaDB_vs_MySQL_testing_env_ 20121008.png "title=" Mariadb_vs_mysql_testing_env_20121008.png "style=" border:0px; "alt=" mariadb_vs_mysql_testing _env_20121008.pn "/>

2.2 Examples of automated test scripts are shown below:

#!/bin/sh#export ld_library_path=/usr/local/mysql/lib/ . ~/.bash_profile >/dev/null  2>&1basedir= "/home/tpcc-mysql" cd  $BASEDIRmkdir  -p  $BASEDIR/logsexec 3> &1 4>&2 1>> tpcc.log 2>&1# executing TPCC test database ipdbip=localhostdbuser= ' root ' dbpass= ' #测试模式: 1000 warehouses wirehouse=1000dbname= "Tpcc${wirehouse}" #数据预热时间: 120 Seconds warmup=120# Execution test duration: 1 hours during=3600# Test mode mode= "PERCONA55_INNODB_BUF26G_1BP_1000DW_XFS_DEADLINE_6DISK_RAID10" #初始化测试环境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 to perform 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>&1donecycle= ' expr  $CYCLE  + 1 ' Done

2.3 Key configuration Options Difference Comparison

Third, test results
Note:

Exclusive means: The use of independent tablespace mode, 1BP/8BP: Set InnoDB buffer pool instance is 1 or 8.

3.1 TPCC Data Initialization comparison
650) this.width=650; "Src=" Http://dp.imysql.com:8080/files/upload_yejr_imysql/MariaDB_vs_MySQL_testing_init_ 20121008.png "title=" Mariadb_vs_mysql_testing_init_20121008.png "style=" border:0px; "alt=" Mariadb_vs_mysql_ TESTING_INIT_20121008.P "/>

Comparison of 3.2 tpmc results
650) this.width=650; "Src=" Http://dp.imysql.com:8080/files/upload_yejr_imysql/MariaDB_vs_MySQL_testing_tpmc_data _20121008.png "title=" Mariadb_vs_mysql_testing_tpmc_data_20121008.png "style=" border:0px; "alt=" MariaDB_vs_MySQL_ testing_tpmc_data_20121 "/>

In this contrast test, the synthesis tpmc under the mode "Percona 5.6.6-m9-56 (exclusive, 1 BP)" (Yellow bottom) is the most efficient. Therefore, the TPMC efficiency of several other test modes is compared directly with it.
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/MariaDB_vs_MySQL_testing_tpmc_ 20121008.png "title=" Mariadb_vs_mysql_testing_tpmc_20121008.png "style=" border:0px; "alt=" Mariadb_vs_mysql_ TESTING_TPMC_20121008.P "/>

Iv. Summary
This time only the TPMC simple contrast benchmark test, MySQL 5.6 and MARIADB announced the various improvements and features are not related.
From the test results, the performance of Percona 5.6 still has a great advantage; In contrast to previous versions, the more concurrent threads are within a certain number of threads, the higher the TPMC efficiency.

--------------------------------------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/1879741

Optimization Series | 5.5 Performance test for MySQL 5.6 vs MariaDB 5.5 vs Percona (TPCC & 5.6)