Documentation Home
MySQL Performance Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb


10.19.2 The clone_progress Table

Note

The Performance Schema table described here is available as of MySQL 8.0.17.

The clone_progress table shows progress information for the current or last executed cloning operation only.

The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. A cloning operation produces a record for each stage. The table therefore only ever contains seven rows of data, or is empty.

The clone_progress table has these columns:

  • ID

    A unique cloning operation identifier in the current MySQL server instance.

  • STAGE

    The name of the current cloning stage. Stages include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY.

  • STATE

    The current state of the cloning stage. States include Not Started, In Progress, and Completed.

  • BEGIN_TIME

    A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage started. Reports NULL if the stage has not started.

  • END_TIME

    A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage finished. Reports NULL if the stage has not ended.

  • THREADS

    The number of concurrent threads used in the stage.

  • ESTIMATE

    The estimated amount of data for the current stage, in bytes.

  • DATA

    The amount of data transferred in current state, in bytes.

  • NETWORK

    The amount of network data transferred in the current state, in bytes.

  • DATA_SPEED

    The current actual speed of data transfer, in bytes per second. This value may differ from the requested maximum data transfer rate defined by clone_max_data_bandwidth.

  • NETWORK_SPEED

    The current speed of network transfer in bytes per second.

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