I have a XenForo powered forum running on my VPS. I get reasonable traffic and my VPS manages just fine at 1500-2000MB RAM. It has been working great until now.
Since the last couple of days. My forum starts showing MySQL related errors during the same time (between 3pm-3.30pm IST) every day. I checked my Cron jobs and I do not think I have anything scheduled around this time to cause the overload.
I filed a complaint through the official route only to be given the usual excuse. Scripts on my domain must be causing the overload. This is despite the fact that I mentioned that the time period I am getting the errors is not a heavy traffic situation on my board. In fact, I get no such issues during the evening time when there is most activity on the forum.
I do not even get any such issue when I run a SQL Dump at 2am in the morning and upload the database backup to Amazon S3.
I have discussed this issue on XenForo community and everything points to the MySQL Server being responsible. I can only assume that another user with access to the same server is running some heavy jobs that overloads it for 15-20 minutes.
When I mentioned this to support, I was asked to check for Traceroute during the downtime. I should mention again… If my connectivity was bad, I would not be seeing MySQL error on the domain.
I do not want to double my hosting costs by paying for a MySQL VPS which I clearly do not require just to avoid this 15-20 minutes of headaches every day.
Can someone suggest what options do I have? Should I start looking for another host already? I really like how I can access all my domains from the same FTP account here on DH and I do not want to go back to cPanel based hosting services!
PS: I also turned on CloudFlare last night. No effect. I also disabled a bunch of addons on XenForo that were not essential. No effect. For obvious reasons.
Here are screenshots from XenForo backend showcasing the error:
As you can see. All the errors are restricted between the twenty minute period. It's 9:45pm right now. No error since 3:31pm. Everything is great since that time.