Lesson 9 of 12 · Performance and operations
Performance in operations: slow queries, EXPLAIN, online indexes, memory and connection pooling
Objective
When faced with "the database is slow", follow an operator's method: measure what costs, explain why, fix without interrupting the service, and verify that the fix worked.
This lesson is part of the full course
Unlock Database administration: MariaDB, MySQL and PostgreSQL in production to read every lesson, do the exercises, access the simulations and earn your certificate.
Already enrolled? Log in.