Actions on currently running queries
Query Details and Kill
Monyog enables you to do the following actions on your threads.
- VIEW the current query for the selected process
- EXPLAIN the query currently executed by the selected process (EXPLAIN works for DML queries only) and this will show the optimized query returned by EXPLAIN EXTENDED if MySQL server supports
- KILL a process
Privileges required for optimal use of this feature
You should notice that to retrieve information about processes of other users, you need the PROCESS (or SUPER) privilege. To kill a process, however, you need the SUPER privilege. Monyog will notify you of the limitations of your permission level (that is, if you do not have full privileges to use all the options provided).
NOTE: This feature is available in Monyog Professional, Enterprise and Ultimate