SavvySavvy Logo
Get Savvy's CLI

Diagnose MySQL slow query performance Issues

1

List all active MySQL processes.

Are you sure you want to delete this step? 

mysql -u <DB_USER> -p <DB_PASSWORD>  -e "SHOW FULL PROCESSLIST;"
2

View the last 100 lines of the MySQL slow query log.

Are you sure you want to delete this step? 

sudo tail -n 100 /var/log/mysql/mysql-slow.log
3

Display the MySQL configuration file.

Are you sure you want to delete this step? 

cat /etc/mysql/my.cnf
4

Show disk space usage in a human-readable format.

Are you sure you want to delete this step? 

df -h
5

View the last 100 lines of the system log.

Are you sure you want to delete this step? 

sudo tail -n 100 /var/log/syslog
6

Check the status of the MySQL service.

Are you sure you want to delete this step? 

sudo systemctl status mysql.service
7

Connect to the database and EXPLAIN a given slow query

Are you sure you want to delete this step? 

mysql -u <DB_USER> -p <DB_PASSWORD> -e "USE <DB_NAME>; EXPLAIN <SLOW_QUERY>"