What Is Actually Happening Under Your Database Queries

Most performance problems I have seen are not the database's fault. They are how it is being used. Missing indexes, long-held transactions, unbounded scans. ACID, query planning, and locking stop being mysterious once you understand what the engine is actually doing.