My Database Can't Handle the Load. What to Do?
summary
The talk examines causes and remedies when a database cannot handle high load, focusing on practical techniques like query optimization, indexing, sharding, replication, caching, and load balancing. It reviews monitoring and diagnostics to find bottlenecks, and outlines trade-offs and deployment approaches for scaling relational and NoSQL systems.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:49Highload and scalability
- 4:02Slowdown causes
- 8:16Two main issues
- 9:18CPU load and monitoring
- 18:44Database memory use
- 26:55Memory problems
- 35:02Disk impact
- 43:09Network role
- 44:17Solutions
- 46:04Infrastructure planning
related talks
01h 00mBurn Brightly So the Database Doesn’t Go Out, or How to Live with High Database Loads
43mPractical Use of NoSQL in a High-Load Project
49mHighLoad Solutions On MySQL
49mHighLoad Solutions On MySQL
49mDatabase Highload: When to Scale and When to Optimize
48mThe DB tamer
49mHighLoad Solutions On MySQL
42mHow to Become a Great Database Specialist