MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
If necessary, you can stop a cloning operation with a
KILL QUERY
statement.
processlist_id
On the recipient MySQL server instance, you can retrieve the
processlist identifier (PID) for a cloning operation from the
PID
column of the
clone_status
table.
Press CTRL+C to copymysql> SELECT * FROM performance_schema.clone_status\G *************************** 1. row *************************** ID: 1 PID: 8 STATE: In Progress BEGIN_TIME: 2019-07-15 11:58:36.767 END_TIME: NULL SOURCE: LOCAL INSTANCE DESTINATION: /path/to/clone_dir/ ERROR_NO: 0 ERROR_MESSAGE: BINLOG_FILE: BINLOG_POSITION: 0 GTID_EXECUTED:
You can also retrieve the processlist identifier from the
ID
column of the
INFORMATION_SCHEMA
PROCESSLIST
table, the
Id
column of SHOW
PROCESSLIST
output, or the
PROCESSLIST_ID
column of the Performance
Schema threads
table. These methods
of obtaining the PID information can be used on the donor or
recipient MySQL server instance.