Comments on: How MySQL 8.0.21 and MariaDB 10.5.4 Perform in IO-Bound Scenarios on SATA SSD and NVMe Storage https://www.percona.com/blog/how-mysql-8-0-21-and-mariadb-10-5-4-perform-in-io-bound-scenarios-on-sata-ssd-and-nvme-storage/ Wed, 03 Jan 2024 15:22:19 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Moll https://www.percona.com/blog/how-mysql-8-0-21-and-mariadb-10-5-4-perform-in-io-bound-scenarios-on-sata-ssd-and-nvme-storage/#comment-10972720 Mon, 21 Sep 2020 18:18:18 +0000 https://www.percona.com/blog/?p=70246#comment-10972720 Could you please share the my.cnf file you used in the test?

]]> By: Marko Mäkelä https://www.percona.com/blog/how-mysql-8-0-21-and-mariadb-10-5-4-perform-in-io-bound-scenarios-on-sata-ssd-and-nvme-storage/#comment-10972587 Tue, 04 Aug 2020 13:01:47 +0000 https://www.percona.com/blog/?p=70246#comment-10972587 We believe that we have repeated the problem that affects I/O bound workloads when the buffer pool consists almost entirely of dirty pages. We have filed https://jira.mariadb.org/browse/MDEV-23399 to track it.

]]> By: Marko Mäkelä https://www.percona.com/blog/how-mysql-8-0-21-and-mariadb-10-5-4-perform-in-io-bound-scenarios-on-sata-ssd-and-nvme-storage/#comment-10972579 Mon, 03 Aug 2020 11:24:58 +0000 https://www.percona.com/blog/?p=70246#comment-10972579 Vadim, unfortunately, my effort to make the InnoDB buf_pool simpler and more performant in the MariaDB 10.5.4 release caused a couple of performance regressions whose fixes will be part of the upcoming 10.5.5 release: https://jira.mariadb.org/browse/MDEV-23017 and https://jira.mariadb.org/browse/MDEV-23369.

The MariaDB performance drop is an interesting anomaly. Could you please share some more details about it, such as some “perf report” output for a “perf record” that covers a badly performing part of the run? Does it occur with the 10.5 branch as of today? If you are not willing to spend time on a development snapshot, I would greatly appreciate it if you could repeat the run on the MariaDB 10.5.5 release and then share more details.

]]> By: Frederick Álvarez https://www.percona.com/blog/how-mysql-8-0-21-and-mariadb-10-5-4-perform-in-io-bound-scenarios-on-sata-ssd-and-nvme-storage/#comment-10972574 Sun, 02 Aug 2020 14:08:41 +0000 https://www.percona.com/blog/?p=70246#comment-10972574 can you run the same test against Oracle 19?

]]>