MySQL :: MySQL 8.4 Reference Manual :: 29.12.19.1 The clone_status Table (original) (raw)

The world's most popular open source database

29.12.19.1 The clone_status Table

The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains one row of data, or is empty.

The clone_status table has these columns:

• ID
  A unique cloning operation identifier in the current MySQL server instance.
• PID
  Process list ID of the session executing the cloning operation.
• STATE
  Current state of the cloning operation. Values includeNot Started, In Progress, Completed, andFailed.
• BEGIN_TIME
  A timestamp in '_`YYYY-MM-DD hh:mm:ss`_[._`fraction`_]' format that shows when the cloning operation started.
• END_TIME
  A timestamp in '_`YYYY-MM-DD hh:mm:ss`_[._`fraction`_]' format that shows when the cloning operation finished. Reports NULL if the operation has not ended.
• SOURCE
  The donor MySQL server address in 'HOST:PORT' format. The column displays 'LOCAL INSTANCE' for a local cloning operation.
• DESTINATION
  The directory being cloned to.
• ERROR_NO
  The error number reported for a failed cloning operation.
• ERROR_MESSAGE
  The error message string for a failed cloning operation.
• BINLOG_FILE
  The name of the binary log file up to which data is cloned.
• BINLOG_POSITION
  The binary log file offset up to which data is cloned.
• GTID_EXECUTED
  The GTID value for the last cloned transaction.

The clone_status table is read-only. DDL, including TRUNCATE TABLE, is not permitted.