Very high CPU usage for mysql..

[Kevan]

Hello all!

Transitioning to a new server due to the newer version's PHP requirements. Got things moved over and now when running, I get mysql (on Ubuntu) running at max CPU. 

Server stats:

AMD EPYC 7401P 24-core, 128gb DDR4 ECC RAM, 2x2TB SSD (dedicated cloud server).

Given the stats I'm wondering what the issue is.

Currently its running php 7.4 so I'll upgrade if needed.. 

Also looking into the setting up of memcache for PHP - what would recommended settings be, and will this help avoid the CPU problem? The idea was to expand our capabilities not have less performance than before..

Advice is most appreciated! Thank you.

[Ian]

Hi Kevan,

Memcache would probably help! It's hard to determine what the best settings for your environment would be, but an important setting for sure is the max amount of connections it can accept (also for MySQL).

Also make sure you have OPcache enabled as PHP module

 

best, Ian

[Kevan]

How does one determine what the max number of connections is? Or its one of those global "0" for overload?

[Ian]

In the memcache configuration file 🙂

[Kevan]

I'm thinking that must be distribution specific.. mine has no mention of it in the config file but I found command line arguments that do the same thing. Thanks!!

[Ian]

Nice! please let us know if it reduced your CPU load