Expert MariaDB Consulting Services

Audits Galera cluster operational status, cluster size, and measures wsrep flow control pause ratios to detect cluster write throttling.

-- 1. Inspect Galera cluster operational state and size
SHOW GLOBAL STATUS LIKE 'wsrep_cluster_status';
SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';
SHOW GLOBAL STATUS LIKE 'wsrep_ready';

-- 2. Audit flow control pause duration (0.0 = none, 1.0 = 100% paused)
SHOW GLOBAL STATUS LIKE 'wsrep_flow_control_paused';
SHOW GLOBAL STATUS LIKE 'wsrep_flow_control_sent';
SHOW GLOBAL STATUS LIKE 'wsrep_flow_control_recv';

-- 3. Check local receive queue average depth
SHOW GLOBAL STATUS LIKE 'wsrep_local_recv_queue_avg';

Verifies whether thread pool is active and inspects worker threads, idle count, and stall metrics to evaluate concurrency headroom.

-- 1. Verify thread handling architecture (pool-of-threads vs one-thread)
SHOW GLOBAL VARIABLES LIKE 'thread_handling';
SHOW GLOBAL VARIABLES LIKE 'threadpool_size';
SHOW GLOBAL VARIABLES LIKE 'threadpool_stall_limit';

-- 2. Inspect thread pool activity and worker thread health
SHOW GLOBAL STATUS LIKE 'Threadpool_threads';
SHOW GLOBAL STATUS LIKE 'Threadpool_idle_threads';

-- 3. Audit thread pool stall events and queued connections
SHOW GLOBAL STATUS LIKE 'Threadpool_stall_%';
SHOW GLOBAL STATUS LIKE 'Threadpool_queued';