Jump to content

Very high CPU usage for mysql..

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...