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

mysqldumpslow /var/lib/mysql/slowquery.log

The related article for this video can be found here:

For more information about this and other topics, visit us at or for more information on our Private Cloud Powered by VMware and NetApp visit:

Video by: Justin Palmer

You May Also Like