The following status variables are useful in binary logging and replication. 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.
Binlog_bytes_written
numeric
Binlog_cache_disk_use
FLUSH STATUS
. numeric
Binlog_cache_use
FLUSH STATUS
. numeric
Binlog_commits
numeric
Binlog_group_commit_trigger_count
numeric
Binlog_group_commit_trigger_lock_wait
numeric
Binlog_group_commit_trigger_timeout
numeric
Binlog_group_commits
numeric
Binlog_snapshot_file
string
Binlog_snapshot_position
numeric
Binlog_stmt_cache_disk_use
FLUSH STATUS
. numeric
Binlog_stmt_cache_use
FLUSH STATUS
. numeric
Com_change_master
numeric
Com_show_master_status
numeric
Com_show_new_master
numeric
MariaDB 5.5
Com_show_slave_hosts
numeric
Com_show_slave_status
numeric
Com_slave_start
numeric
MariaDB 10.0
Com_slave_stop
numeric
MariaDB 10.0
Com_start_all_slaves
numeric
Com_start_slave
numeric
Com_stop_all_slaves
numeric
Com_stop_slave
numeric
Master_gtid_wait_count
numeric
Master_gtid_wait_time
numeric
Master_gtid_wait_timeouts
numeric
Rpl_status
Rpl_transactions_multi_engine
mysql.gtid_slave_pos
. These are transactions that were already cross-engine, independent of the GTID position update introduced by replication. The global value can be flushed by FLUSH STATUS
. numeric
Slave_connections
numeric
Slave_heartbeat_period
numeric
Slave_open_temp_tables
numeric
Slave_received_heartbeats
numeric
Slave_retried_transactions
FLUSH STATUS
. numeric
Slave_running
numeric
Slave_skipped_errors
numeric
Slaves_connected
numeric
Slaves_running
numeric
Transactions_gtid_foreign_engine
gtid_slave_pos
table had to choose a storage engine that did not otherwise participate in the transaction. This can indicate that setting gtid_pos_auto_engines might be useful. The global value can be flushed by FLUSH STATUS
. numeric
Transactions_multi_engine
FLUSH STATUS
. numeric
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/replication-and-binary-log-status-variables/