MorningBigBlue Posted August 12, 2023 Posted August 12, 2023 Starting about 5 days ago, something has started pinning CPU usage over 100% when it is typically averages under 50%. It is making the site very slow and unresponsive. I've turned off every other website running to narrow it down to IP Board. I'm using Cloudron to manage the sites. If I restart the container running the board, it will get responsive for a short term before it starts to bog down again. Have done no changes recently to the website or configuration. If I run htop, I can see a mysqld process running at high cpu usage, and it will keep running for days if I don't restart the server. When I log into mysql, I can't see any queries running that match that. Have had the Cloudron folks take a look at this, and they think it is something with the board software. Can't see anything wrong on their end. Any thoughts on next steps on this?
Adriano Faria Posted August 12, 2023 Posted August 12, 2023 I would disabled 3rd-party apps/plugins to make sure isn’t one of them.
Miss_B Posted August 12, 2023 Posted August 12, 2023 16 minutes ago, MorningBigBlue said: Starting about 5 days ago, something has started pinning CPU usage over 100% when it is typically averages under 50%. Something has caused the sike, as it doesn't happen out of nowhere. High CPU is caused by inefficient queries. (poorly indexed or poorly designed) queries, I would start as adviced by Adriano, to disable all third party plugins/apps and see if it will help. If it does, enable them one at a time until you find the culprit. What is the value set to for join_buffer_size?
MorningBigBlue Posted August 12, 2023 Author Posted August 12, 2023 (edited) Turned them all off, wasn't until I turned off the Forums app that it had any effect. Turned it back on and CPU usage spiked again. Was up and down for a bit, but seems to be stuck at > 100% again. Similar behaviour to a restart. join_buffer_size is 262144 Edited August 12, 2023 by MorningBigBlue
Marc Posted August 14, 2023 Posted August 14, 2023 You would need to contact your hosting company to take a look at your mysql configuration. There is nothing specific I can see wrong with your installation
Recommended Posts