What do you mean with database CPU saturation?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.
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 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
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?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.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