November 14, 2026 · Zwiegnet Consulting
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.
Read More
November 2, 2026 · Zwiegnet Consulting
Tune PostgreSQL 18 on AlmaLinux 10: size shared_buffers, work_mem and WAL settings, enable pg_stat_statements, read EXPLAIN ANALYZE plans, add the right indexes and keep autovacuum ahead of the workload.
Read More
September 13, 2026 · Zwiegnet Consulting
Index SQL Server Database Index SQL Server 2008R2 Database Every once in a while it’s a good idea to re-index your tables when you are using Microsoft SQL Server. Unlike…
Read More