Basic Administration Manual: Blocking, Performance, and Basic Configuration in MySQL / MariaDB
Ready-to-run scripts to review blocked InnoDB transactions, slow queries, and validate innodb_buffer_pool_size.
100% digital delivery. The manual and files are sent by email after payment is confirmed.
Summary
Problem it solves
Have a set of proven scripts on hand for the daily check of blocking, performance, and configuration in MySQL/MariaDB, without having to rebuild them every time.
Who it is for
DBAs or system administrators who operate MySQL or MariaDB (InnoDB) in production and need a repeatable technical checklist.
Who it is not for
Anyone looking for a guide specific to multi-source replication or clustering (Galera/Group Replication) — this manual covers single-instance operation.
What's included
- Reviewing blocking: INNODB_TRX and active transactions
- Active locks and the blocker-blocked relationship (performance_schema)
- Safely terminating sessions (KILL QUERY / KILL CONNECTION)
- Reviewing performance: SHOW ENGINE INNODB STATUS
- Slow queries: slow query log and events_statements_summary_by_digest
- Index usage and detecting table scans
- Buffer pool hit ratio
- Basic configuration: innodb_buffer_pool_size
- Connections, timeouts, and the redo log (innodb_flush_log_at_trx_commit)
- Basic replication configuration checklist
- Consolidated daily health-check script
Technical information
Included files
- PDF manual with the diagnostic scripts included in the text
Lab evidence
Lab evidence: in preparation
This guide has no public evidence yet. Once published, it will include anonymized screenshots of the real execution, with no hostnames, private IPs, usernames or client data.
Licenses
Version history
- 1.0 — 2026-07-28: First published edition.
READY FOR THIS GUIDE?