Hi i’m configuring a master slave setup with percona Server version: 8.0.34-26. In the mysql official doc I see that now we have tables in the performance_schema to monitor the replication and they say that if we select the column thread_id of this table performance_schema.replication_applier_status_by_coordinator we can then go to information_schema.processlist in th ecolumn ID to get the message ‘Replica has read all relay log; waiting for more updates’ in the state column.
For me it does not work the thread_id column in performance_schema.replication_applier_status_by_coordinator does not correspond to the one in information_schema.processlist
mysql> SELECT THREAD_ID,SERVICE_STATE FROM performance_schema.replication_applier_status_by_coordinator;
±----------±--------------+
| THREAD_ID | SERVICE_STATE |
±----------±--------------+
| 79 | ON |
±----------±--------------+
1 row in set (0.00 sec)
mysql> SELECT ID,STATE FROM information_schema.processlist pro where ID=79;
Empty set (0.00 sec)
In procces list the correct ID is 29 :
mysql> SELECT ID,STATE FROM information_schema.processlist pro where state like ‘%has read all relay%’;
±—±---------------------------------------------------------+
| ID | STATE |
±—±---------------------------------------------------------+
| 29 | Replica has read all relay log; waiting for more updates |
±—±---------------------------------------------------------+
1 row in set (0.00 sec)
The same thing for the IO_THREAD. What am i doing wrong ?