MariaDB Performance Tuning on AlmaLinux 10: InnoDB Buffer Pool, Slow Query Log and Indexes
Tune MariaDB on AlmaLinux 10: size the InnoDB buffer pool and redo log, set flush, connection and temp table limits, enable and rotate the slow query log, analyze it with mariadb-dumpslow and pt-query-digest, and fix slow queries with EXPLAIN, ANALYZE and indexes.