• Marko Mäkelä's avatar
    MDEV-23475 InnoDB performance regression for write-heavy workloads · 309302a3
    Marko Mäkelä authored
    In commit fe39d02f (MDEV-20638)
    we removed some wake-up signaling of the master thread that should
    have been there, to ensure a steady log checkpointing workload.
    
    Common sense suggests that the commit omitted some necessary calls
    to srv_inc_activity_count(). But, an attempt to add the call to
    trx_flush_log_if_needed_low() as well as to reinstate the function
    innobase_active_small() did not restore the performance for the
    case where sync_binlog=1 is set.
    
    Therefore, we will revert the entire commit in MariaDB Server 10.2.
    In MariaDB Server 10.5, adding a srv_inc_activity_count() call to
    trx_flush_log_if_needed_low() did restore the performance, so we
    will not revert MDEV-20638 across all versions.
    309302a3
srv0srv.cc 89.1 KB