MySQL Performance: Identifying Long Queries

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

The related article for this video can be found here: https://www.liquidweb.com/kb/mysql-performance-identifying-long-queries/

For more information about this and other topics, visit us at https://www.liquidweb.com/kb/ or for more information on our Private Cloud Powered by VMware and NetApp visit: https://www.liquidweb.com/products/private-cloud/.

Video by: Justin Palmer

You May Also Like