Skip to content
  • Karthik Kamath's avatar
    d73f98b3
    BUG#29049207: SLAVE PERFORMANCE DEGRADES OVER TIME · d73f98b3
    Karthik Kamath authored
    ANALYSIS:
    =========
    If a slave instance use sysvar_session_track_gtids ==
    OWN_GTID and with MTS enabled, the slave will lag behind
    master and its performance degrades over time.
    
    Each slave worker adds its own gtid into its
    Session_consistency_gtids_ctx.m_gtid_set during each
    transaction commit. Overtime, the
    Session_consistency_gtids_ctx.m_gtid_set may have
    gno_interval in millions and thus will take long time to
    insert a gtid into Session_consistency_gtids_ctx.m_gtid_set.
    This causes the lag/performance degrade.
    
    FIX:
    ====
    Disable tracking GTIDs for slave threads.
    
    Note:
    =====
    This patch is based on a contribution by Facebook.
    
    RB#25006
    d73f98b3
    BUG#29049207: SLAVE PERFORMANCE DEGRADES OVER TIME
    Karthik Kamath authored
    ANALYSIS:
    =========
    If a slave instance use sysvar_session_track_gtids ==
    OWN_GTID and with MTS enabled, the slave will lag behind
    master and its performance degrades over time.
    
    Each slave worker adds its own gtid into its
    Session_consistency_gtids_ctx.m_gtid_set during each
    transaction commit. Overtime, the
    Session_consistency_gtids_ctx.m_gtid_set may have
    gno_interval in millions and thus will take long time to
    insert a gtid into Session_consistency_gtids_ctx.m_gtid_set.
    This causes the lag/performance degrade.
    
    FIX:
    ====
    Disable tracking GTIDs for slave threads.
    
    Note:
    =====
    This patch is based on a contribution by Facebook.
    
    RB#25006
Loading