MySQL Performance: Identifying Long Queries

October 8, 2020 Liquid Web

Every MySQL backed-application can benefit from a finely-tuned database server. In this video, we demonstrate how to identify long-running MySQL queries.

Commands used:
mysqladmin -u root -p proc stat
mysql  -u root -p 
show full processlist;

vim /etc/my.cnf
slow_query_log=1
slow_query_log_file=/var/lib/mysql/slowquery.log
long_query_time=5

mysqldumpslow /var/lib/mysql/slowquery.log

Video by: Justin Palmer

About the Author

Liquid Web

Liquid Web powers online content, commerce, and potential for SMB entrepreneurs and the designers, developers and digital agencies who create for them. Sign up for our <a href="https://www.liquidweb.com/blog">newsletter</a> to stay up to date with our latest content.

More Content by Liquid Web
Previous Video
Troubleshooting Microsoft SQL Server Error 18456, Login failed for user
Troubleshooting Microsoft SQL Server Error 18456, Login failed for user

In this video, we demonstrate how to troubleshoot the MSSQL Server Error 18456 Login Failed for User.

Next Video
MySQL Performance: How To Leverage MySQL Database Indexing
MySQL Performance: How To Leverage MySQL Database Indexing

In this video, we demonstrate how to do leverage MySQL database indexing.

Learn What Qualities to Look for in Your Next Host in Our New Guide!

Download Now