29.12.11.6 The replication_applier_progress_by_worker Table

This table provides replication applier statistics, such as wait times, wait counts, transaction counts, event counts, and byte counts, for a given worker.

Note

This table requires installation of the replication_applier_metrics component, which is available with MySQL Enterprise Edition only. See Section 7.5.6, “Replication Applier Metrics Component”, for more information.

The replication_applier_progress_by_worker table has these columns:

• CHANNEL_NAME

  The name of the replication channel.

• WORKER_ID

  The worker ID.

• THREAD_ID

  The thread ID of the applier thread.

• ONGOING_TRANSACTION_TYPE

  The type of transaction being executed; one of UNASSIGNED, DML, or DDL. The type of a given transaction is known only after its associated GTID event has been processed. Until then, its type is shown as UNASSIGNED.

  This information is available only for workers executing transactions.

• ONGOING_TRANSACTION_FULL_SIZE_BYTES

  The total size (in bytes) of transactions currently being executed by this worker. This increases for the first GTID seen or (for compressed transactions) the first transaction payload event scheduled for each transaction, and decreases when a transaction is committed.

  This information is available only for workers executing transactions.

• ONGOING_TRANSACTION_APPLIED_SIZE_BYTES

  The size (in bytes) of the parts of transactions that were already executed for the worker ongoing transaction. This increases with each event executed (provided that the event provides a data size), and is reset when the transaction is committed.

  This information is available only for workers executing transactions.

The replication_applier_progress_by_worker table was added in MySQL 9.1.0.