Hi. We have a site that has a problem with the Wordpress child theme and as a result, is putting a lot of pressure on the database, the Select is at 98%. There are too many dependancies on the database, like the code even when the site is not used is pinging the database. The site is stable for around 30 minutes then it crashes as a result of this. We need the database dependancies to be lower than 50% at all times. We need this work done asap, please are there any experts (not time wasters) that can resolve this fast? Thanks Matt
You have a few choices get a new theme debug the existing theme to identify the problem query and make appropriate changes - either DIY, or hire someone
Hi Matt, check the Slow Query log and see which select are taking so much time.... 1. Install a wordpress plugin called p2p. you can check the time taken for each plugins or theme and it will also give you statistics... 2. Generally Themes do not call the database so often, because there is no data stored by them...it is mostly settings they save... i think it is a bad plugin....... the other alternative is disabling plugins one by one to know which plugin is creating an issue 3. Another alternative is to add a Caching plugin......it will cache your database queuries 4. Do you have a translator plugin?...check that first
I am wondering if someone is exploiting a vulnerability that is inside of the theme, or a plugin that you use. Especially if it is a free to use theme, found online and installed manually, I would not continue to use the theme. Change the theme, then I would have wordfence scan your site for security issues. On another note, from experience, poorly coded article script plugins for wordpress also tend to overload the sql server. If switching the theme does not resolve the problem, then disable plugins, one by one, until you find the culprit. I know you want to hire someone to fix it. But IMHO, it might be better to pay for a solid solution that works from the start, then paying someone to muck around trying to patch the titanic.
Have you tried switching to the Twenty Seventeen theme, and waiting the 30 minute interval to see if the issue still happens? That would easily prove it was the theme. If that works, do you have a recent copy of the theme from the developer to compare your version to theirs? Also, are there any specific functions this website performs? Any special plugins? Have you tried deactivating the plugins and waiting the 30 minute interval?
Why don't you hire some experienced and reliable company who has experience of product engineering projects..!