Sample Header Ad - 728x90

MariaDB 4-5 times slower than Oracle

1 vote
0 answers
73 views
since Oracle will increase the costs for running databases my employer is currently evaluating alternatives for oracle databases. In one application we currently use oracle db with no specific settings. To test everything we migrated the same database to mariadb and ran some tests. One test takes with mariadb 18 minutes and with oracle only 4-5 minutes. Our tests runs a few (hundred/thousand?) Select queries in the same table with different parameters. I know, that maybe oracle has some caching feature which might cache the selected table, but 4-5 times slower is something I can't believe for MariaDB. The server MariaDB is running on is a Oracle Linux 8.10; the same as the oracle db but different host. MariaDB Version is 10.5.27. Is there any setting we can tweak for MariaDB? Thanks a lot for your ideas and help.
Asked by Marcus (11 rep)
May 16, 2025, 06:45 AM