MySQL 8.4 · Performance and maintenance
See running queries
List the connections and the statements they are running.
SHOW FULL PROCESSLIST;
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
- Refresh index statistics
- Check a server setting
- Count open connections
All performance and maintenance commands · MySQL 8.4 cheatsheet