Becoming a DBA for 5 minutes a day, the most important things to know for sysadmins and developers
summary
Checklist of concrete fixes and diagnostics: update old MySQL versions, stop running with default configs, set innodb_buffer_pool_size correctly, disable query cache in most cases, set innodb_flush_log_at_trx_commit per durability needs, avoid storing blobs in the DB, use memcache or caching layer and connection pooling, treat slaves as replicas not backups and test restore time, use pt-query-digest/Percona Toolkit and pt-stalk for slow queries and post-mortems, monitor iostat/mysqld stats to spot backup-induced CPU/load spikes.
AI-written summary · about
chapters (12)
- 0:005-minute DBA role
- 1:47Common DB problems
- 3:35Resource allocation & I/O bottlenecks
- 5:00Query optimization & caching
- 8:13Performance troubleshooting
- 11:29Server updates & repo management
- 12:53Storage engine choice
- 15:27MySQL config essentials
- 19:02Memory & swapping risks
- 22:43Monitoring & query analysis
- 25:36Caching & indexing best practices
- 27:05Disclaimer & closing
