MySQL Performance: Identifying Long Queries

Skip ad
11 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

LiquidWeb
Published
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
Category
Liquid Web
Tags
liquidweb, datacenter, web
Be the first to comment