I have noticed that every 24 hours at exactly 12:10 GMT my forum is experiencing major MySQL lag which also shows in the slow-query log. I presume this is related to some sort of forum cron job. The slow queries that appear in the log are from other processes so it seems that XenForo is hogging the MySQL usage during this time.
Does anyone have any advice on any ways we could resolve this issue? The main issue is that we have other processes which use MySQL running on the same server which are being badly affected by whatever is going on.