Mysql Patterns

This is a production-focused reference for MySQL and MariaDB work that covers schema design, indexing strategy, transaction patterns, and connection pooling. It starts with version checks because the two databases have diverged on syntax like upsert row aliases, then walks through composite index ordering, keyset pagination instead of deep offsets, queue patterns with SKIP LOCKED, and deadlock prevention through deterministic lock ordering. The examples are concrete, from DECIMAL for money to pool_recycle settings aligned with server wait_timeout. Useful when you're reviewing migrations on large tables, debugging lock waits, or setting up connection pools that won't leak or timeout under load.