I have been facing high mysql load for 3 days from an account on my dedicated server which is using joomla 2.5.4
I know its caused by that account, because when is disconnect from mysql everything works fine in the server.
My server is already managed by professional company and they are still looking at the issue from mysql slow query logs.
However I am really unpatient that my problem should be find and corrected as soon as possible.
This site, 6000+ articles, 96000 member also using jomsocial, 20 000 + photos phoca gallery, 450 items at mosets tree, 200+ outsourced(vimeo) videos at hwd videshare
Since the problem is very new I dont think the server is not enough for it.
I want a person who will find the problem on the joomla web site and fix it. And turn mysql load normal
The reason should be find in 48 hours, I already tried enable/disable components modules way.
9 freelancers are bidding on average $136 for this job
Hi, Let's finish now we can convert sql to store procedure if require. Let's see your code. We can solve your [url removed, login to view] done big projects in php, mysql & custom cms like joomla, wordpress. Thanks