Find blocked processes in Mailwizz?

[sjones6587]

Is there a way to run an SQL/MySQL command to get a list of running processes? Hopefully there's a "Blocked by" column there. I'm looking to find, and possibly kill the process to get things moving again. If there's a command to kill a running process, can someone at least give me that? I'm looking online and haven't found any. I don't have much experience in SQL so please be gentle.

 

[ghimes]

Hello,
You can use SHOW FULL PROCESSLIST . Here is the documentation: https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html.
You can kill a process just like in the CLI with KILL PID.

Cosmin