How to optimize forums to avoid database CPU saturation?

[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

[warmweer]

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?

[Mick]

Did you speak to your provider at all?

[Madalin10]

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.

[Harrison76]

the database is 2 GB and I have 4 GB of RAM

[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

[ssl]

What kind of error message do you get?
This type of problem is generally linked to the host, have you asked them?

[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

[ssl]

What kind of error message do you get?

[Harrison76]

no error messages, it just crashes when you click and takes a few minutes to change pages

[ssl]

Have you tried disabling all your extensions to see if that changes anything?

[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

[ssl]

If you can't do the research on your own it's going to be complicated. Good luck.

[invenio]

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.

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?

[bonelifer]

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.