Movatterモバイル変換

If necessary, you can stop a cloning operation with aKILL QUERYprocesslist_id statement.

On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from thePID column of theclone_status table.

mysql> 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 theID column of theINFORMATION_SCHEMAPROCESSLIST table, theId column ofSHOW PROCESSLIST output, or thePROCESSLIST_ID column of the Performance Schemathreads table. These methods of obtaining the PID information can be used on the donor or recipient MySQL server instance.