MySQL 8.4 · Performance and maintenance
Refresh index statistics
Update the key distribution statistics the optimizer uses.
ANALYZE TABLE users;
Official MySQL 8.4 documentation
More performance and maintenance commands
- See a query's plan
- Run a query and see real timings
- Create an index
- See running queries
- Check a server setting
- Count open connections
All performance and maintenance commands · MySQL 8.4 cheatsheet