-
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
Karthik Kamath authoredANALYSIS: ========= 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