mahigupta/mysql_process.md

Last active August 9, 2019 20:48

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mahigupta/945903f4adf6eaf4a213cd46e3110525.js"></script>
Save mahigupta/945903f4adf6eaf4a213cd46e3110525 to your computer and use it in GitHub Desktop.

Download ZIP

Mysql long running query debugging

Raw

mysql_process.md

to debug long runnign queries in mysql/mariadb

show ENGINE innodb status;
show status like '%';
show processlist;
Show status like "Threads%";
Select substring_index(host, ':', 1) as host_name,state,count(*) from information_schema.processlist group by state,host_name;
Show global variables like '%';