How to optimize forums to avoid database CPU saturation?

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Harrison76
Registered User
Posts: 268
Joined: Wed Jul 12, 2017 7:25 am

How to optimize forums to avoid database CPU saturation?

Post by Harrison76 »

Hi everyone, despite having brought the managed hosting plan to the maximum possible, and also having increased the database RAM to the maximum possible, I am still struggling with database CPU saturation and I no longer know how to resolve it. Is there some setting on the site or database that you can try to change to lighten the load, or is it inevitable to move the site to another provider with greater performance, but also higher costs? Thank you
User avatar
warmweer
Jr. Extension Validator
Posts: 11868
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: How to optimize forums to avoid database CPU saturation?

Post by warmweer »

Harrison76 wrote: Wed Jul 17, 2024 5:27 am I am still struggling with database CPU saturation and I no longer know how to resolve it.
What do you mean with database CPU saturation?

What's the size of your database? Is it optimised?
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26874
Joined: Fri Aug 29, 2008 9:49 am

Re: How to optimize forums to avoid database CPU saturation?

Post by Mick »

Did you speak to your provider at all?
  • "The more connected we get the more alone we become” - Kyle Broflovski© 🇬🇧
User avatar
Madalin10
Registered User
Posts: 117
Joined: Wed Jun 18, 2014 2:42 pm
Name: Madalin C.

Re: How to optimize forums to avoid database CPU saturation?

Post by Madalin10 »

Harrison76 wrote: Wed Jul 17, 2024 5:27 am Hi everyone, despite having brought the managed hosting plan to the maximum possible, and also having increased the database RAM to the maximum possible, I am still struggling with database CPU saturation and I no longer know how to resolve it. Is there some setting on the site or database that you can try to change to lighten the load, or is it inevitable to move the site to another provider with greater performance, but also higher costs? Thank you
If you are hosting your site/board on a shared webhost, it may be problematic if your site has a huge database and files indeed. A VPS (virtual private server) would be a much better choice in that case.
https://awesome-web.design - I offer phpBB & web design services at fair prices.
Harrison76
Registered User
Posts: 268
Joined: Wed Jul 12, 2017 7:25 am

Re: How to optimize forums to avoid database CPU saturation?

Post by Harrison76 »

the database is 2 GB and I have 4 GB of RAM
Harrison76
Registered User
Posts: 268
Joined: Wed Jul 12, 2017 7:25 am

Re: How to optimize forums to avoid database CPU saturation?

Post by Harrison76 »

I tried to optimize it in the past but little changes: when it gets saturated for a few minutes the site doesn't respond, you click and it doesn't change the page for those minutes, then it unlocks
User avatar
ssl
Registered User
Posts: 2025
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: How to optimize forums to avoid database CPU saturation?

Post by ssl »

What kind of error message do you get?
This type of problem is generally linked to the host, have you asked them?
Sorry for my English ... I do my best! :anger_right:

:point_right_tone3: phpBB: 3.3.14 | PHP: 8.3.12
:point_right_tone4: [Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Harrison76
Registered User
Posts: 268
Joined: Wed Jul 12, 2017 7:25 am

Re: How to optimize forums to avoid database CPU saturation?

Post by Harrison76 »

yes, I opened the ticket but they haven't responded yet: in the past they said it was our business and that we needed to optimize the site
User avatar
ssl
Registered User
Posts: 2025
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: How to optimize forums to avoid database CPU saturation?

Post by ssl »

What kind of error message do you get?
Sorry for my English ... I do my best! :anger_right:

:point_right_tone3: phpBB: 3.3.14 | PHP: 8.3.12
:point_right_tone4: [Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Harrison76
Registered User
Posts: 268
Joined: Wed Jul 12, 2017 7:25 am

Re: How to optimize forums to avoid database CPU saturation?

Post by Harrison76 »

no error messages, it just crashes when you click and takes a few minutes to change pages
User avatar
ssl
Registered User
Posts: 2025
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: How to optimize forums to avoid database CPU saturation?

Post by ssl »

Have you tried disabling all your extensions to see if that changes anything?
Sorry for my English ... I do my best! :anger_right:

:point_right_tone3: phpBB: 3.3.14 | PHP: 8.3.12
:point_right_tone4: [Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Harrison76
Registered User
Posts: 268
Joined: Wed Jul 12, 2017 7:25 am

Re: How to optimize forums to avoid database CPU saturation?

Post by Harrison76 »

no, because the forum is very active and I don't want to cause damage, then the problem doesn't have an immediate response but could occur after days. One thing comes to mind, some time ago I allowed searches to be done even for just 2 characters. could it have had an impact? I remember that the database immediately increased in size. However, it is an important function for us so I wouldn't want to remove it. Thank you
User avatar
ssl
Registered User
Posts: 2025
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: How to optimize forums to avoid database CPU saturation?

Post by ssl »

If you can't do the research on your own it's going to be complicated. Good luck.
Sorry for my English ... I do my best! :anger_right:

:point_right_tone3: phpBB: 3.3.14 | PHP: 8.3.12
:point_right_tone4: [Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
User avatar
invenio
Registered User
Posts: 429
Joined: Wed Dec 09, 2015 1:45 pm
Location: New Hampshire, USA

Re: How to optimize forums to avoid database CPU saturation?

Post by invenio »

Harrison76 wrote: Wed Jul 17, 2024 4:38 pm no, because the forum is very active and I don't want to cause damage, then the problem doesn't have an immediate response but could occur after days. One thing comes to mind, some time ago I allowed searches to be done even for just 2 characters. could it have had an impact? I remember that the database immediately increased in size. However, it is an important function for us so I wouldn't want to remove it. Thank you
Why would disabling an extension "cause damage?" Would it be a huge deal to turn off extensions for 30 minutes to see if that is the issue? Sounds like the most simple first step.
Harrison76 wrote: Wed Jul 17, 2024 4:38 pm no, because the forum is very active and I don't want to cause damage, then the problem doesn't have an immediate response but could occur after days. One thing comes to mind, some time ago I allowed searches to be done even for just 2 characters. could it have had an impact? I remember that the database immediately increased in size. However, it is an important function for us so I wouldn't want to remove it. Thank you
Why not try and put the search parameter back to 3 characters, rebuild the search database and see if that was it?
User avatar
bonelifer
Community Team Member
Community Team Member
Posts: 3628
Joined: Wed Oct 27, 2004 11:35 pm
Name: William

Re: How to optimize forums to avoid database CPU saturation?

Post by bonelifer »

Harrison76 wrote: Wed Jul 17, 2024 4:38 pm no, because the forum is very active and I don't want to cause damage, then the problem doesn't have an immediate response but could occur after days. One thing comes to mind, some time ago I allowed searches to be done even for just 2 characters. could it have had an impact? I remember that the database immediately increased in size. However, it is an important function for us so I wouldn't want to remove it. Thank you
You could put it back to 3 and rebuild. Then install https://www.phpbb.com/customise/db/exte ... glesearch/ create your own Google Search Engine key, and in google's search peg it to just your site. This way only results from your site showed up.
William Jacoby - Community Team
Knowledge Base | phpBB Board Rules | Search Customisation Database
Please don't contact me via PM or email for phpBB support .

phpBB Modders is looking for developers! If you have phpBB experience and want to join us, click here!

Return to “[3.3.x] Support Forum”