Topic
SQLiteBeginnerWhat WAL mode changes compared with the default rollback journal, what it costs, when not to use it, and how to turn it on, check it and switch back.
#concurrency#configuration#transactions
SQLiteAdvancedHow the -wal and -shm files, read marks and checkpoints work, why a WAL grows without bound, and how to set checkpointing, journal_size_limit and synchronous.
#concurrency#configuration#internals
PostgreSQLIntermediateRaising max_connections to 1000 usually makes things worse. Learn why Postgres connections are expensive, where they're leaking and how PgBouncer fixes it for good.
#configuration#performance#troubleshooting
ElasticsearchIntermediateYellow means missing replicas and red means missing primaries. Use the allocation explain API to find the exact cause: replica count, disk watermarks, allocation filters or failed retries.
#configuration#nosql#troubleshooting
Oracle DatabaseIntermediateYour long query needed undo that was already overwritten. How Oracle read consistency uses undo, how to read V$UNDOSTAT, and why committing inside a loop causes it.
#configuration#mvcc#troubleshooting
SQL ServerBeginnerIt's caching by design, not a leak, but the default limit is 'everything'. How to set max server memory and tell real memory pressure from a full buffer pool.
#configuration#internals#performance
