Kevan Posted November 22, 2022 Report Posted November 22, 2022 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. Quote
Ian Posted November 22, 2022 Report Posted November 22, 2022 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 Quote
Kevan Posted November 22, 2022 Author Report Posted November 22, 2022 How does one determine what the max number of connections is? Or its one of those global "0" for overload? Quote
Ian Posted November 22, 2022 Report Posted November 22, 2022 In the memcache configuration file 🙂 Quote
Kevan Posted November 22, 2022 Author Report Posted November 22, 2022 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!! Quote
Ian Posted November 22, 2022 Report Posted November 22, 2022 Nice! please let us know if it reduced your CPU load Quote
Recommended Posts
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.