Cheat Sheets
DBA Cheat Sheet Library
Production-verified queries for daily DBA operations, incident triage, and performance profiling.
Featured Reference Posters
Printable & Offline DBA Cheat Sheets
postgresql
PostgreSQL 16 / 17psql CLI Quick Reference
Complete PostgreSQL Command Line Reference
Connection Strings & URI Syntax
Complete Meta Commands (\dt+, \dn+, \du)
Output & Formatting Options
mysql
MySQL 8.0 / 8.4InnoDB Tuning Reference
MySQL InnoDB Storage Engine Performance Tuning Guide
Buffer Pool Sizing Formula (70-80%)
Redo Log & O_DIRECT Configuration
Production my.cnf Ready Template
postgresql
PostgreSQL 15 / 16 / 17PostgreSQL Security Hardening
End-to-End Database Hardening Guide for Production Systems
SCRAM-SHA-256 & Secure pg_hba.conf
Least Privilege & public Schema Lockdown
TLS/SSL verify-full Configuration
postgresql
PostgreSQL 14 / 15 / 16 / 17PostgreSQL Backup & Recovery Reference
PostgreSQL Backup, PITR & Disaster Recovery Guide
pg_dump & pg_dumpall Optimal Flags
WAL Archiving & Non-Blocking Physical Backups
Point-in-Time Recovery (PITR) Walkthrough
mysql
MySQL 8.0 / 8.4MySQL Backup & Recovery Reference
MySQL Backup, Binary Log PITR & CLONE Guide
mysqldump --single-transaction & Fast Restore
MySQL Shell Parallel dumpInstance / loadDump
Minute-Accurate PITR with Binary Logs
postgresql
PostgreSQL 14 / 15 / 16 / 17PostgreSQL Indexing & Query Optimization
PostgreSQL Index Types, EXPLAIN ANALYZE & Query Tuning
B-Tree, GIN, GiST & BRIN Index Selection Guide
EXPLAIN (ANALYZE, BUFFERS) Execution Plan Reading
Index Skip Scan, Partial & Expression Indexes
mysql
Oracle 1Z0-908 · MySQL 8.0MySQL OCP 8.0 DBA Exam Topic Map
Comprehensive Study & Quick Reference Guide for Oracle 1Z0-908
All 7 Exam Domains & High-Risk Exam Pitfalls
InnoDB Cluster, Group Replication & Router
Crucial MySQL 8.0 Default Values to Memorize
Kategori:
mysqltroubleshoot Safe / Read-Only
BASICInspect Running Threads & Blocked Queries
Queries performance views to find threads in execution state exceeding execution thresholds.
#processlist#slow queries#troubleshoot
mysqlperformance Safe / Read-Only
INTERMEDIATECheck InnoDB Engine Status & Latest Deadlock Trace
Displays semaphore waits, latest deadlock transaction dumps, and buffer pool hit ratios.
#innodb#deadlock#locks
mysqlperformance Safe / Read-Only
INTERMEDIATECalculate InnoDB Buffer Pool Hit Ratio
Calculates cache hit efficiency. A ratio lower than 99% indicates buffer pool size should be increased.
#buffer pool#memory#performance