Re: Quickly Cover Slave Replication Lag

[Irfan Ahamd]

Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id Master_UUID Master_Info_File SQL_Delay SQL_Remaining_Delay Slave_SQL_Running_State Master_Retry_Count Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position Replicate_Rewrite_DB Channel_Name Master_TLS_Version
-------------------------------------- ----------- ----------- ----------- ------------- ------------------- ------------------- ------------------ ------------- --------------------- ---------------- ----------------- --------------- ------------------- ------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- --------------------------- ---------- ---------- ------------ ------------------- --------------- --------------- -------------- ------------- ------------------ ------------------ ------------------ --------------- ----------------- -------------- --------------------- ----------------------------- ------------- ------------- -------------- -------------- --------------------------- ---------------- ------------------------------------ ------------------------------------- --------- ------------------- ------------------------------------------------------ ------------------ ----------- ----------------------- ------------------------ -------------- ------------------ ------------------ ----------------- ------------- -------------------- ------------ --------------------
Queueing master event to the relay log 4.4.4.4 pep_super 3306 60 slave_logbin.001734 546085556 slave_relay.005203 546085326 slave_logbin.001734 Yes Yes 0 0 546085107 546086028 None 0 No 0 No 0 0 179 )-1d26-11ea-877b-000d3a9f5de1 /udddddata/mysql_installed/master.info 0 (NULL) Slave has read all relay log; waiting for more updates 86400 0

Please copy above lines into notepad for correct order.

All tables have PK
We are using only INNODB engine
We are using ROW based replication