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-pe...
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/pr....
Video by: Justin Palmer
