Marc Stridgen Posted June 14 Share Posted June 14 9 hours ago, sadams101 said: I'm the server admin, and so far I've traced this to the update mentioned in this thread. Nothing on my server as far as hardware has changed, and the server is running a low server load with plenty of extra memory, disk storage, etc. 12 hours ago, Jim M said: You can enable slow query logging to see if this is MySQL end. You hosting provider can also advise what else is happening and provide us further data to investigate. Link to comment Share on other sites More sharing options...
sadams101 Posted June 18 Author Share Posted June 18 After manually running this today...as mentioned if fails about once per day now and needs to be manually run, I saw this, which I've never seen before: Link to comment Share on other sites More sharing options...
Marc Stridgen Posted June 19 Share Posted June 19 We really could do with getting a slow query log running, as mentioned a couple of times above G17 Media 1 Link to comment Share on other sites More sharing options...
sadams101 Posted June 19 Author Share Posted June 19 I'm not sure how that would impact a busy server like mine...as I understand it could be fairly taxing in size and might cause performance issues, but I will look into this more. Link to comment Share on other sites More sharing options...
Jim M Posted June 19 Share Posted June 19 11 minutes ago, sadams101 said: I'm not sure how that would impact a busy server like mine...as I understand it could be fairly taxing in size and might cause performance issues, but I will look into this more. To be blunt here, if you do not wish to enable this, we may never get to the bottom of your issue here as you appear to be the only one reporting this issue. It is up to yourself to live with the current issue or enable slow query logging. You can start at a higher threshold and only log queries which take 10 seconds or longer and if you don't get any (which shouldn't be the case if it is as you state), you can decrease it. Slow query logging when configured correctly on a performant server should not pose any major resource issue but of course, doing anything extra will cause more resource consumption. However, generally, you enable it when you are having a resource issue so the consumption isn't a great concern as you need it to resolve the bigger consumption at hand. sadams101 and G17 Media 1 1 Link to comment Share on other sites More sharing options...
Recommended Posts