MariaDB Enterprise Solutions & Support

Monitors cluster-wide quorum membership, node sync state, and flow-control pauses causing write-pipeline throttling across nodes.

-- Inspect Galera cluster size, node state, and quorum health
SHOW STATUS LIKE 'wsrep_cluster_size';
SHOW STATUS LIKE 'wsrep_local_state_comment';

-- Detect flow control pauses stalling cluster-wide writes (threshold > 0.0)
SHOW STATUS LIKE 'wsrep_flow_control_paused';
SHOW STATUS LIKE 'wsrep_local_recv_queue_avg';

Surfaces active transactional deadlocks, longest-running uncommitted transactions, and Aria pagecache efficiency.

-- Inspect active InnoDB transactional locks, lock waits, and deadlocks
SHOW ENGINE INNODB STATUS;
SELECT trx_id, trx_state, trx_started, trx_wait_started, trx_query 
FROM information_schema.innodb_trx ORDER BY trx_started ASC LIMIT 10;

-- Check Aria storage engine pagecache efficiency and transactional locks
SHOW STATUS LIKE 'Aria_pagecache%';
SHOW STATUS LIKE 'Aria_transactional%';