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

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)

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

Cited by

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

Authors

Katarzyna Krocz 
katarzyna.krocz@pollub.edu.pl
Lublin University of Technology Poland

Authors

Oleksandra Kizun 

Lublin University of Technology Ukraine

Authors

Maria Skublewska-Paszkowska 

Lublin University of Technology Poland

Statistics

Abstract views: 1256
PDF downloads: 2307