How to kill MySQL process under specified user?

StelarBlack

• November 25, 2015 15:01

I have user which is doing a SELECT query on large database, and usually this query runs over 20000 seconds, and MySQL fails. I am watching MySQL processes on Home >> SQL Services >> Show MySQL Processess, but I can't find this particular process in Process Manager. This query runs from users PhpMyAdmin, and isn't visible under Proccess Manager, where MySQL query which is runs from user SSH session's mysql command line is visible. How can I indentify and kill such process, without restarting MySQL server?

• 

  cPanelMichael

  • November 25, 2015 20:12

  Hello :) You have to kill the processes via the "mysql" command line. There's a third-party URL where this is discussed at: How do I kill all the processes in Mysql "show processlist"? Thank you.

  0

Please sign in to leave a comment.