Hi again, I'm looking forward to some update on the page flushing. On Wed, Apr 10, 2024 at 2:37 PM Gordan Bobic <gordan.bobic@gmail.com> wrote:
On Wed, Apr 10, 2024 at 2:16 PM Marko Mäkelä <marko.makela@mariadb.com> wrote:
I don't remember what exactly innodb_log_write_ahead_size was supposed to do. The log writing was simplified and made compatible with O_DIRECT and physical block sizes up to 4096 bytes, in MDEV-14425, which is available in MariaDB Server 10.11.
innodb_log_write_ahead_size is supposed to ensure that redo log is padded out to that size.
Based on https://jira.mariadb.org/browse/MDEV-33894 and https://smalldatum.blogspot.com/2024/04/sysbench-on-less-small-server-mariad... this needs to be addressed in MariaDB Server 10.11. Marko -- Marko Mäkelä, Lead Developer InnoDB MariaDB plc