mysql_processlist
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mysql_processlist [2016/05/20 09:23] – luke7858 | mysql_processlist [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 3: | Line 3: | ||
== Query List == | == Query List == | ||
To view mysql query list run the following command from the command line: | To view mysql query list run the following command from the command line: | ||
+ | <sxh bash> | ||
+ | SELECT * FROM information_schema.processlist WHERE command != ' | ||
+ | </ | ||
+ | |||
+ | \\ | ||
+ | |||
<sxh bash> | <sxh bash> | ||
mysqladmin pr | grep Query | sort -nk12 | mysqladmin pr | grep Query | sort -nk12 |
mysql_processlist.1463736227.txt.gz · Last modified: 2024/05/23 07:26 (external edit)