Semisynchronous Replication Plugin Status Variables
You are viewing an old version of this article. View
the current version here.
Contents
- Rpl_semi_sync_master_clients
- Rpl_semi_sync_master_net_avg_wait_time
- Rpl_semi_sync_master_net_wait_time
- Rpl_semi_sync_master_net_waits
- Rpl_semi_sync_master_no_times
- Rpl_semi_sync_master_no_tx
- Rpl_semi_sync_master_status
- Rpl_semi_sync_master_timefunc_failures
- Rpl_semi_sync_master_tx_avg_wait_time
- Rpl_semi_sync_master_tx_wait_time
- Rpl_semi_sync_master_tx_waits
- Rpl_semi_sync_master_wait_pos_backtraverse
- Rpl_semi_sync_master_wait_sessions
- Rpl_semi_sync_master_yes_tx
- Rpl_semi_sync_slave_status
This page documents status variables related to the Semisynchronous Replication Plugin. See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.
See also the Full list of MariaDB options, system and status variables.
Rpl_semi_sync_master_clients
- Description: Number of semisynchronous slaves.
- Data Type:
numeric
Rpl_semi_sync_master_net_avg_wait_time
- Description: Average time the master waited for a slave to reply, in microseconds.
- Data Type:
numeric
Rpl_semi_sync_master_net_wait_time
- Description: Total time the master waited for slave replies, in microseconds.
- Data Type:
numeric
Rpl_semi_sync_master_net_waits
- Description: Total number of times the master waited for slave replies.
- Data Type:
numeric
Rpl_semi_sync_master_no_times
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_no_tx
- Description: Number of commits that have not been successfully acknowledged by a slave.
- Data Type:
numeric
Rpl_semi_sync_master_status
- Description: Whether or not semisynchronous replication is currently operating on the master. The value will be
ON
if both the plugin has been enabled and a commit acknowledgment has occurred. It will be #OFFif either the plugin has not been enabled, or the master is replicating asynchronously due to a commit acknowledgment timeout.
- Data Type:
boolean
Rpl_semi_sync_master_timefunc_failures
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_tx_avg_wait_time
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_tx_wait_time
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_tx_waits
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_wait_pos_backtraverse
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_wait_sessions
- Description:
- Data Type:
numeric
Rpl_semi_sync_master_yes_tx
- Description: Number of commits that have been successfully acknowledged by a slave.
- Data Type:
numeric
Rpl_semi_sync_slave_status
- Description: Whether or not semisynchronous replication is currently operating on the slave.
ON
if both the plugin has been enabled and the slave I/O thread is running. - Data Type:
boolean
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.