Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Done
-
10.6.16
-
None
Description
The SQL_Remaining_Delay value isn't displayed accurately as per the comment from Elkin.
The calculation for the value isn't always correct.
Formula |
Seconds_Behind_Master + SQL_Remaining_Delay == SQL_Delay
|
Examples |
Seconds_Behind_Master: 45292 |
Master_SSL_Verify_Server_Cert: No
|
Last_IO_Errno: 0 |
Last_IO_Error:
|
Last_SQL_Errno: 0 |
Last_SQL_Error:
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 1 |
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: Current_Pos
|
Gtid_IO_Pos: 1-1-1092846621 |
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: optimistic
|
SQL_Delay: 43200 |
SQL_Remaining_Delay: 6655 |
Slave_SQL_Running_State: Waiting until MASTER_DELAY seconds after master executed event
|
------------------------------------------------------------------------------
|
Seconds_Behind_Master: 26766 |
Master_SSL_Verify_Server_Cert: No
|
Last_IO_Errno: 0 |
Last_IO_Error:
|
Last_SQL_Errno: 0 |
Last_SQL_Error:
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 2 |
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: Slave_Pos
|
Gtid_IO_Pos: 1-2-3787175 |
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: optimistic
|
SQL_Delay: 21600 |
SQL_Remaining_Delay: 631 |
Slave_SQL_Running_State: Waiting until MASTER_DELAY seconds after master executed event
|
------------------------------------------------------------------------------
|
Seconds_Behind_Master: 31298 |
Master_SSL_Verify_Server_Cert: No
|
Last_IO_Errno: 0 |
Last_IO_Error:
|
Last_SQL_Errno: 0 |
Last_SQL_Error:
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 2 |
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: Slave_Pos
|
Gtid_IO_Pos: 1-2-4740170 |
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: optimistic
|
SQL_Delay: 21600 |
SQL_Remaining_Delay: 354 |
Slave_SQL_Running_State: Waiting until MASTER_DELAY seconds after master executed event
|