I run a popular news service that relies on Geeklog. We are very happy with Geeklog, but this is one of those weekends where spammers are causing a massive headache.
Our main Geeklog site has been offline for much of the past 24 hours. What I'm seeing on the backend, when I look at our MySQL databases through phpMyAdmin, are lots of sleeping processes associated with the Geeklog site. We've also experienced a flood of spam yesterday and today, most of which has been intercepted by the Bad Behavior plug-in. Our site has slowed to a crawl and the obvious symptom is the plethora of sleeping MySQL processes.
We've restarted MySQL but that hasn't resolved the problem.
Can anybody shed any light on this problem?
Chuck