ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #mariadb
Step‑by‑step guide to diagnose MariaDB InnoDB lock wait timeout errors, check variables, identify blocking transactions, add indexes, adjust timeouts, and decide when to escalate.
Want to see what a row looked like yesterday? MariaDB’s system‑versioned tables keep every change automatically. This post walks through how they work, a point‑in‑time query example, the unbounded‑history trade‑off, and how to prune history with partitions.
Deploy a three‑node MariaDB Galera Cluster for synchronous replication and zero‑loss failover. Includes prerequisites, configuration, bootstrapping, health checks, recovery, and operational caveats.
Learn how to use MariaDB’s table partitioning to split large tables into smaller, query‑friendly segments. This guide covers the core syntax, a practical range‑partition example, and common pitfalls to avoid.
Stop relying on full table scans for JSON data. Learn how to use MariaDB Virtual Generated Columns to index specific JSON keys for relational-speed performance.
Decide whether to use InnoDB or Aria for a MariaDB table based on transactions, foreign keys, locking, and memory.
A practical diagnostic guide for MariaDB slowdowns caused by an undersized InnoDB buffer pool, with a cause table, ordered checks, fixes tied to findings, and escalation criteria.
MariaDB system-versioned tables provide automatic row history with SQL:2011 time-travel queries. Learn the partitioned storage model, production trade-offs, and an operational checklist for implementation.
Learn how to run an online ALTER TABLE in MariaDB with ALGORITHM=INPLACE and LOCK=NONE, verify the result, and recover safely from interruptions.
json