# Performance MySQL 5.1.30 to Maria 5.5.23

**URL:** <https://forums.percona.com/t/performance-mysql-5-1-30-to-maria-5-5-23/1815>\
**Category:** Other MySQL® Questions\
**Created:** [May 22, 2012, 10:05am UTC](https://forums.percona.com/t/performance-mysql-5-1-30-to-maria-5-5-23/1815 "2012-05-22T10:05:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kakawait](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kakawait/32/872_2.png) [@kakawait](https://forums.percona.com/u/kakawait)\
**Post date:** [May 22, 2012, 10:05am UTC](https://forums.percona.com/t/performance-mysql-5-1-30-to-maria-5-5-23/1815/1 "2012-05-22T10:05:27Z")

</div>

Hello,

My RDBMS environnent currently use MySQL 5.1.30 but I intend to upgrade MySQL to MariaDB or Percona server (5.5 branch) server.

I started with MariaDB 5.5.23 (will try Percona just after).

MySQL and MariaDB are on the same server, with different data dir but in the same partition. (mysqldump to import/export)  
MariaDB use the same configuration file.

port = 3307   
socket = /tmp/maria.sock   
[mysqld]  
port = 3307   
socket = /tmp/maria.sock   
max\_allowed\_packet = 67108864   
table\_cache = 1024   
myisam\_sort\_buffer\_size = 64M   
thread\_concurrency = 16   
log-bin=mysql-bin   
server-id = 1   
max\_connections = 4096   
slow\_query\_log = 1   
long\_query\_time = 2   
binlog\_format=mixed   
expire\_logs\_days = 14   
wait\_timeout=1800   
interactive\_timeout=1800   
join\_buffer\_size = 262144   
key\_buffer\_size = 4096M

query\_cache\_limit = 8M   
query\_cache\_size = 64M   
query\_prealloc\_size = 16384   
read\_buffer\_size = 4194304   
read\_rnd\_buffer\_size = 16777216   
sort\_buffer\_size = 4194304   
thread\_cache\_size = 64   
tmp\_table\_size = 67108864   
transaction\_alloc\_block\_size = 16384  
transaction\_prealloc\_size = 8192   
innodb\_file\_per\_table   
innodb\_flush\_method=O\_DIRECT   
innodb\_log\_file\_size = 1G   
innodb\_buffer\_pool\_size = 10G   
default-storage-engine = innodb   
group\_concat\_max\_len = 1M   
[mysqldump]  
quick  
max\_allowed\_packet = 67108864  
[mysql]  
no-auto-rehash  
[isamchk]  
key\_buffer = 256M  
sort\_buffer\_size = 256M  
read\_buffer = 2M  
write\_buffer = 2M  
[myisamchk]  
key\_buffer = 256M  
sort\_buffer\_size = 256M  
read\_buffer = 2M  
write\_buffer = 2M  
[mysqlhotcopy]  
interactive-timeout

I selected few queries from my application to try performance.  
Unfortunately I was disappointed with the performance of Mariadb almost 1,5 times slower…

Databases contains ~200 Innodb tables and many triggers & stored procedures but no(or not many) transactions.

I use simple php script and / or profiling option to get these results.

Someone should have an idea? Maybe 5.1 branch is faster for my application than 5.5

PS:SQL\_NO\_CACHE is used to avoid cache and when I test mariadb, mysql is shutdown vice versa

EDIT:  
For some query, EXPLAIN between MySQL and Maria is different for the same query (on column Extra)  
Example  
MySQL  
±---------------------------------------------+  
| Extra  
±---------------------------------------------+  
| Using where; Using temporary; Using filesort  
| Using where  
±---------------------------------------------+  
2 rows in set (0.01 sec)  
Mariadb  
±---------------------------------------------------------- ----------+  
| Extra  
±---------------------------------------------------------- ----------+  
| Using index condition; Using where; Using temporary; Using filesort  
| Using where  
±---------------------------------------------------------- ----------+  
2 rows in set (0.01 sec)