Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual 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:


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


    Reserved for future use.


    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.)


    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

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