• Aditya A's avatar
    Bug #23070734 CONCURRENT TRUNCATE TABLES CAUSE STALLS · 62dca454
    Aditya A authored
    PROBLEM
    
    When truncating single tablespace tables, we need to scan the entire
    buffer pool to remove the pages of the table from the buffer pool.
    During this scan and removal dict_sys->mutex is being held ,causing
    stalls in other DDL operations.
    
    FIX
    
    Release the dict_sys->mutex during the scan and reacquire it after the
    scan. Make sure that purge thread doesn't purge the records of the table
    being truncated and background stats collection thread skips the updation
    of stats for the table being truncated.
    
    [#rb 14564 Approved by Jimmy and satya ]
    62dca454
dict0stats_bg.cc 13.1 KB