Semisynchronous Replication Plugin Status Variables

You are viewing an old version of this article. View the current version here.

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: Number of times the master turned off semisynchronous replication.
  • 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 #OFF if 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: Number of times the master failed when calling a time function, such as gettimeofday().
  • Data Type: numeric

Rpl_semi_sync_master_tx_avg_wait_time

  • Description: Average time the master waited for each transaction, in microseconds.
  • Data Type: numeric

Rpl_semi_sync_master_tx_wait_time

  • Description: Total time the master waited for transactions, in microseconds.
  • Data Type: numeric

Rpl_semi_sync_master_tx_waits

  • Description: Total number of times the master waited for transactions.
  • 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.