Issue See CPU load per subscription (including MySQL)?

[lanix343]

Server operating system version

Debian 11.11

Plesk version and microupdate number

Plesk Obsidian v18.0.71_build1800250729.09 os_Debian 11.0

Hi everyone,


we’re running a Plesk server (Debian 11, AMD EPYC, 16 cores, 64 GB RAM) with LiteSpeed as the webserver. In Plesk we can only see the overall CPU usage, which right now is heavily driven by MySQL (around 80% of the load). We cannot even see what is causing the load on a subscription level. The subscription monitoring tool of plesk is not giving out any useful indication or data.


Is there any way to see the CPU load broken down per subscription or domain? Ideally including MySQL queries, so we can identify which website/subscription is actually causing the high load.


Plesk itself doesn’t seem to show this directly. Do you use specific tools, extensions or external monitoring solutions for this?


Thanks in advance!

 

[lanix343]

anyone and idea?

 

[Sebahat.hadzhi]

Hello, @lanix343 . Monitoring extension + built-in monitoring + Cgroups Manager. Please check:

• How to Use Cgroups Manager to Increase Website Performance Through Resource Isolation on Linux - Plesk

 

[lanix343]

Thanks, will this also work with litespeed plesk server extension installed and litespeed active instead of apache?

 

[Sebahat.hadzhi]

No, cgroups doesn't natively work on LiteSpeed on Plesk. I can see that you clarified it is a LiteSpeed server in your initial post. Apologies for the confusion. As far as I can see it can be integrated:

• cgroups | LiteSpeed Web Server | LiteSpeed Documentation

However, I have not personally tested that and I cannot confirm for sure if it will work.

 

[lanix343]

No, cgroups doesn't natively work on LiteSpeed on Plesk. I can see that you clarified it is a LiteSpeed server in your initial post. Apologies for the confusion. As far as I can see it can be integrated:

• cgroups | LiteSpeed Web Server | LiteSpeed Documentation

However, I have not personally tested that and I cannot confirm for sure if it will work.

Thanks this has really helped me.

 

[SafeWp]

[late to the party] but the cgroup manager and monitoring extension do work with litespeed (you just have to disable 360 monitoring and the enable "Integrate with Customer Subscriptions" in the monitor settings page How to Use Cgroups Manager to Increase Website Performance Through Resource Isolation on Linux - Plesk

For what you were tryin to do though (diagnose a performance issue) the `htop` cli tool would be much more useful. Plesk's monitoring only reports 5 minute averages but you would need live data.