MySQL 8.4 · Performance and maintenance
See a query's plan
Show how MySQL plans to run a query.
EXPLAIN SELECT * FROM users WHERE email = '[email protected]';
Official MySQL 8.4 documentation
More performance and maintenance commands
- Run a query and see real timings
- Create an index
- Refresh index statistics
- See running queries
- Check a server setting
- Count open connections
All performance and maintenance commands · MySQL 8.4 cheatsheet