I have created two identicals VMs to test percona.
Both with CentOS 6.5 64bits, 2 vCPU and 1GB of memory
I used sysbench to do a test and get the result bellow (transactions per second)
Both database populated with the same command.
sysbench --db-driver=mysql --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=root --mysql-password=123456 prepare
Percona-Server-server-55-5.5.36-rel34.1.el6.x86_64
for i in $(seq 1 5); do echo $(date “+%Y-%m-%d %H:%M:%S”) " " $(sysbench --db-driver=mysql --num-threads=32 --max-requests=100000 --test=oltp --oltp-table-size=1000000 --mysql-socket=/var/lib/mysql/mysql.sock --oltp-read-only --mysql-user=root --mysql-password=123456 run | grep transactions: | cut -f2 -d’(’ | cut -f1 -d’ '); sleep 10; done
2014-03-25 11:27:07 2368.71 per sec.
2014-03-25 11:28:00 2465.49 per sec.
2014-03-25 11:28:51 2497.78 per sec.
2014-03-25 11:29:42 2442.25 per sec.
2014-03-25 11:30:33 2445.34 per sec.
Percona-Server-server-56-5.6.16-rel64.2.el6.x86_64
for i in $(seq 1 5); do echo $(date “+%Y-%m-%d %H:%M:%S”) " " $(sysbench --db-driver=mysql --num-threads=32 --max-requests=100000 --test=oltp --oltp-table-size=1000000 --mysql-socket=/var/lib/mysql/mysql.sock --oltp-read-only --mysql-user=root --mysql-password=123456 run | grep transactions: | cut -f2 -d’(’ | cut -f1 -d’ '); sleep 10; done
2014-03-25 11:44:48 2005.92 per sec.
2014-03-25 11:45:48 2035.94 per sec.
2014-03-25 11:46:48 2041.90 per sec.
2014-03-25 11:47:47 2035.28 per sec.
2014-03-25 11:48:47 2037.31 per sec.
The file /etc/my.cnf is the same.
Why the new version is worst than older?