Web interface server query very slow

[xlauz]

Hello, I've had the community running for a few months now and recently the web interface has become very sluggish with some queries taking over 60 seconds to complete.

I have tried enabling MySQL cache (64Mb) I can't even tell if it made a difference. Sometimes the query executes fast, but most of the time they take over 60 seconds. I have checked MySQL settings and am running multiple other databases with no performance problems, and CPU usage is not a problem either.

I notice this problem when clicking on nearly any link within the web interface, but some still do work consistently however. The Header URLS (Dashboard,Bans,Servers,Report player,Appeal ban,Administration) as well as the Administration URLS (Admins,Bans,Groups,Servers,Games,Settings) certainly are affected.

The following link discusses the same problem: https://forums.alliedmods.net/showthread.php?t=233068

Would be nice if someone could have a look into this and get back with some feedback on possible causes.

Thanks in advance