Why Is My Query Slow and How to Fix It
summary
Explains why a database query is slow by dividing causes into two categories: high CPU time (the query itself is expensive) or wait time (the query is blocked waiting for resources). Shows how to determine which of those is responsible, examines common waits (resource types the query may be waiting for), and gives ways to speed up the query.
AI-written summary · about
chapters (10)
- 0:00Query optimization
- 7:24High CPU time
- 15:09High CPU weight
- 18:05SQL Server waits
- 24:30Data sync latency
- 29:35Low duration high weight
- 36:51Parallelism issues
- 43:26Scalar functions impact
- 47:35Spinlocks costs
- 53:51Optimization summary
related talks
35mSlow database in your PHP stack? Don't blame the DBA!
55mLet's Talk About MySQL Query Tuning
58m"Run Query Run" - A Fresh Look at SQL Wait Stats
28mMy Cypher Query Takes Too Long. What Can I Do ?
59m"Run Query Run" - A Fresh Look at SQL Wait Stats
58mTroubleshooting CPU Performance Issue for SQL Developers
45mPHP's biggest bottleneck, MySQL
57mQuery Performance Analysis in ClickHouse