Serendipity overloaded my server

[ChadwickHugh]

First off I want to say I love(d) Serendipity, but today I was greeted with a not so friendly message when I visited my webpage. Instead of my normal homepage I had a message in black text saying my account had been suspended and that I needed to contact the host asap. I checked my email and found the following (note DB xxxxxx_chad is my serendipity DB):

Hello,

Your site has been suspended for using too many server resorces. You need
to move this site to a dedicated server. The excessive usage was over 70
simulatinous queries to the databases:
xxxxxx_bbforum
xxxxxx_chad

I've never had this happen while using this host for over a year. I responded and asked what the problem was:

xxxxxx_chad is mainly the problem can I remove that database and reopen your account?

Any clue why this would occur? My blog had less than 5 entries and less than 5 people even knew about it, yet somehow it overloaded my server. In order to get my site back up I had to have the DB deleted.

[nohn]

Did you use persistent connection? That is gerenally a bad idea!

[garvinhicking]

You could also try this patch: http://blog.s9y.org/archives/13-SQL-Spe ... mance.html

[Oliver]

Sorry for the (perhaps dump) question, but how do I apply this patch?

[garvinhicking]

Hm, the general idea is: if you don't know how, you probably don't want to apply it at all.

The easier way would be to download a 0.9 SVN snapshot via BerliOS, or via ViewSVN on the repository and then just copy the include/plugin_api.inc.php file to your 0.8.x installation.

If you want to know more about patch, google "gnu patch diff"

Regards,
Garvin