Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
Replication IO_Thread call SELECT GTID_BINLOG_POS even when MASTER_USE_GTID=NO and GTID is disabled.
Id: 49525
|
User: replica
|
Host: XXXXX.XXXX.XXXX.XXXXX
|
db: NULL
|
Command: Query
|
Time: 61
|
State: executing
|
Info: SELECT binlog_gtid_pos('mysql-binlog.XXXXX',XXXXXXXX)
|
Progress: 0.000
|
|
..
|
...
|
......
|
Using_Gtid: No
|
Gtid_IO_Pos:
|
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: conservative
|
SQL_Delay: 0
|
SQL_Remaining_Delay: NULL
|
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
|
|
This unnecessary query execution can hang IO thread for significant time, Causing slave lag (MDEV-25764)
Attachments
Issue Links
- is caused by
-
-
- Closed
-
- mentioned in
-
Page Loading...
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-