Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.4Mb
PDF (A4) - 35.6Mb
PDF (RPM) - 33.8Mb
EPUB - 8.5Mb
HTML Download (TGZ) - 8.3Mb
HTML Download (Zip) - 8.4Mb
HTML Download (RPM) - 7.2Mb
Eclipse Doc Plugin (TGZ) - 9.2Mb
Eclipse Doc Plugin (Zip) - 11.3Mb
Man Pages (TGZ) - 198.4Kb
Man Pages (Zip) - 302.4Kb
Info (Gzip) - 3.2Mb
Info (Zip) - 3.2Mb
Excerpts from this Manual

23.9.11.4 The replication_applier_status Table

This table shows the current general transaction execution status on the slave server. This table was added in MySQL 5.7.2 with the name replication_execute_status, and renamed to replication_applier_configuration in MySQL 5.7.6.

This table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status information is available in the replication_applier_status_by_coordinator table (and replication_applier_status_by_worker if the slave is multi-threaded).

The replication_applier_status table has these columns:

  • CHANNEL_NAME

    The replication channel which this row is displaying. There is always a default replication channel, and more replication channels can be added. See Section 18.2.3, “Replication Channels” for more information.

  • SERVICE_STATE

    Reserved for future use.

  • REMAINING_DELAY

    If the slave is waiting for DESIRED_DELAY seconds to pass since the master applied an event, this field contains the number of delay seconds remaining. At other times, this field is NULL. (The DESIRED_DELAY value is stored in the replication_applier_configuration table.)

  • COUNT_TRANSACTIONS_RETRIES

    Added in MySQL 5.7.5, shows the number of retries that were made because the slave SQL thread failed to apply a transaction.

The following table shows the correspondence between replication_applier_status columns and SHOW SLAVE STATUS columns.

replication_applier_status ColumnSHOW SLAVE STATUS Column
SERVICE_STATENone
REMAINING_DELAYSQL_Remaining_Delay

User Comments
Sign Up Login You must be logged in to post a comment.