Playbook #9 Increase in Slow Queries on DB
Slow queries can result in degraded performance and responsiveness of the system. The playbook will help identify the slow queries which are currently running and it's impact on the system performance.
Check the overall CPU and memory usage of the server
top
Check the MySQL process list to identify any long-running queries
mysql -u ${USERNAME} -p${PASSWORD} -e "SHOW FULL PROCESSLIST;"
Check the MySQL slow query log file for any recent entries
sudo tail -n 100 /var/log/mysql/mysql-slow.log
Check the system logs for any relevant errors or warnings
sudo tail -n 100 /var/log/syslog
check Mysql service status
sudo systemctl status mysql.service