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
Watch video MySQL Performance: Identifying Long Queries online without registration, duration hours minute second in high quality. This video was added by user Liquid Web 20 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,937 once and liked it 18 people.