Query Details and Kill

SQL DM for MySQL 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 shows 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. 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).



SQL Diagnostic Manager for MySQL agentless and cost-effective performance monitoring for MySQL and MariaDB.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels