CPU Usage Stats on Admin Panel

Hey guys,

Not really a server guy but got a dedicated server really just to manage one website and trying to figure out if I'm doing something wrong.

Not a high end server but Intel dual code, 16GB, 4TB to run a Magento store.

My issue is the following, I keep getting the website blocked after running queries. In the processes panel I see 100% CPU...

Yet the actual CPU monitor below is barely showing 5%.





Just confused. I setup. cgroups to allocate the majority to the account.

Another testing website on the same server still works fine while the main site is blocked and also the admin panel so the server is not overloaded.

Anyone who knows more about this stuff than me if they could help a guy out!

Thanks!

check mysql max connects and are you getting any specific error?

> Anyone who knows more about this stuff than me if they could help a guy out!

It must be investigated and guessing too bad in your case.

I've run a Magento store under CWP in a similar setup -- basically 1:1 using the whole VM with similar specs (10GB RAM, 2 CPU cores). You will need to do specific DB tuning for Magento, along with specific cron jobs they recommend. Don't forget to secure the installation as well. It looks by your process list MariaDB is consuming the bulk of the CPU, which shouldn't really be the case when your tuning is finished. Generally, Magento installs are heavy on the PHP processing side of things, so you may want to put Nginx in front of the site, or even Varnish. That way a cache handles most of the page displays until someone creates an e-commerce account at the storefront and then needs live interaction with the web app.