• Marko Mäkelä's avatar
    MDEV-26636: InnoDB defragmentation statistics cause races on TEMPORARY TABLE · 3209bc66
    Marko Mäkelä authored
    btr_defragment_save_defrag_stats_if_needed(): Do not save
    defragmentation statistics for temporary tables.
    They are exempt of defragmentation anyway
    (ha_innobase::optimize() never invokes defragmentation for them),
    and the user-visible names are not available inside InnoDB.
    
    Furthermore, InnoDB assumes that temporary tables are never accessed
    by other threads than the one that handles the session with which
    the temporary table is associated with.
    
    Furthermore, we simplify the test innodb.innodb_defrag_stats
    and include a test case that demonstrates that defragmentation
    statistics are no longer being saved for temporary tables.
    3209bc66
innodb_defrag_stats.test 4.73 KB