Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2
Katarzyna Krocz
katarzyna.krocz@pollub.edu.plLublin 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 analysisReferences
[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].
[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].
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
Oleksandra KizunLublin University of Technology Ukraine
Authors
Maria Skublewska-PaszkowskaLublin University of Technology Poland
Statistics
Abstract views: 1360PDF downloads: 2529
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
