A comparison of database performance of MariaDB and MySQL with OLTP workload

摘要

Information and data are increasing and has rapid growth as we now are in big data era. Database management system becomes a major part of data centers. This paper compared the performance of an open source database management system between MySQL and MariaDB. The testing environment is Xen 4.4 virtual machine using OLTP-Simple and OLTP-Seats as the benchmark data. Our experiment results show that MySQL has significantly better performance than MariaDB. MySQL performance rate are doubled at 1,000 threads of OLTP-Simple with 4 workers of OLTP-Seats while the resource consuming were similar in all cases. Therefore, MySQL version 5.6 has better performance than MariaDB version 10.0.21.