Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2


Abstract

This article will compare the performance of relational databases MySQL, PostgreSQL, MariaDB and H2. The speed of executing will be tested on simple and more complex SQL queries. The tests results will show which database is more efficient.


Keywords

DBMS; relational model; performance analysis

[1] Y. Abubakar, Benchmarking popular open source RDBMS: a performance evaluation for it professionals, International Journal of Advanced Computer Technology (IJACT), 2014.
[2] S. Tongkaw, A. Tongkaw, A Comparison of Database Performance of MariaDB and MySQL with OLTP Workload, IEEE Conference on Open Systems (ICOS), 2016.
[3] M. Meekyung, Experiments of Search Query Performance for SQL-Based Open Source Databases, International Journal of Internet, 2018.
[4] R. Poljak, P. Pošcić, D. Jakšić, Comparative Analysis of the Selected Relational Database Management Systems, MIPRO, 2017.
[5] Ranking SZBD według ich popularności, https://db engines.com/en/ranking, [20.03.2019].
[6] Opis bazy MySQL, https://pl.wikipedia.org/wiki/MySQL, [20.03.2019].
[7] Dokuntacja MySQL, https://dev.mysql.com/doc/, [20.03.2019].
[8] Opis bazy MariaDB, https://en.wikipedia.org/wiki/MariaDB, [20.03.2019].
[9] Silnik MyRocks, https://mariadb.com/kb/en/library/about-myrocks-for-mariadb/, [20.03.2019].
[10] J. D. Drake , J. C. Worsley, Practical PostgreSQL, O’Reilly Media, Inc., 2002.
[11] Dokumentacja PostgreSQL, https://www.postgresql.org/docs/11/index.html, [20.03.2019].
[12] Opis bazy H2, https://en.wikipedia.org/wiki/H2_(DBMS), [20.03.2019].
[13] Strona bazy H2, http://www.h2database.com/html/main.html, [20.03.2019].
Download

Published : 2020-03-30


Krocz, K., Kizun, O., & Skublewska-Paszkowska, M. (2020). Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2. Journal of Computer Sciences Institute, 14, 1-7. https://doi.org/10.35784/jcsi.1565

Katarzyna Krocz  katarzyna.krocz@pollub.edu.pl
Lublin University of Technology  Poland
Oleksandra Kizun 
Lublin University of Technology  Ukraine
Maria Skublewska-Paszkowska 
Lublin University of Technology  Poland