MY SQL running at 90% - Web site is bogged down - culprit?
Hello. I have the latest mambo CMS, 4.5.4 with the latest security updates. Recently my server was running at 90% of MY SQL resource usage. I restarted MY SQL and now it is running fine. I do not want this to happen again.
My ISP suggested I check any newer scripts that I have installed on my server. They said I can also check for updates to any web applications that I have installed. Finally they said my server does not log with enough detail to determine the source of the high usage.
Since the only programs installed on my server that uses mysql are mambo and its components, modules and mambots, what should I look for in trouble shooting why my server is running at 90% usage? What would point to the culprit? This is the first time this has happened since I moved to a new server a few days ago. I understand from my isp there are no mysql log files.
Please advise and thank you.