Resolved with monitor 360, how to list out SQL queries running, so you can kill one

[larryk]

Server operating system version

CentOS Linux 7.9.2009 (Core)

Plesk version and microupdate number

Plesk Obsidian v18.0.43_build1800220414.18 os_CentOS 7

Today, I added 360 Monitoring, the trial...
Somehow, I was looking at a list of SQL queries, where I actually killed one.

VERY NICE, easy, etc.

I need to do this again, but can't find that screen/page or how I did it before?

do you know where to look?
I just can't find it.

thanks

 

[IgorG]

What about

https://your.tld:8443/modules/repair-kit/index.php/db-process-manager

?

 

[Nik G]

hello @larryk ,

probably it was at Plesk 360
where you can choose metric type = mysql

but as I know it should just show in read-only mode, without ability to terminate queries.

probably it was Tools&Settings > Database servers > %exact server% > Webadmin icon (at the end of server name line
then in web admin UI Status > Processes

as I can see, this is the place where it is possible to terminate queries.

 

[larryk]

THANK YOU Igor!!! Bingo!
well, it is easy to find, once I know what I was looking for

MySQL Process List (Beta)​

Nik, I tried to follow your menu option path... but didn't find it?


but also found this:

https://your.tld:8443/modules/repair-kit/index.php/process

Which is also VERY NICE!!

thank you both!
PS. new tip I learned... use the "search field " at the very top of Plesk admin.