Query Details and Kill
SQL DM for MySQL enables you to do the following actions on your threads:
VIEWthe current query for the selected process.
EXPLAINthe query currently executed by the selected process (EXPLAIN works for DML queries only) and this shows the optimized query returned by EXPLAIN EXTENDED if MySQL server supports.
Privileges required for optimal use of this feature
You should notice that to retrieve information about processes of other users, you need the
SUPER) privilege. However, to kill a process you need the SUPER privilege. SQL DM for MySQL notifies you of the limitations of your permission level (that is, if you do not have full privileges to use all the options provided).