My b2evolution Version: 1.9.x

Hi,

I have some problems with a crashing server. An entire server? Yep, an entire server. :-/

When our site is accessed a lot of times per minute, say > 100 times, the database starts lagging. There are a lot of requests waiting for eachother.

Even the most simple queries start to pop up in my long-query logs and sometimes take as long as 20 seconds.

In the end MySQL crashes and takes the whole dedicated server with it. (yikes!)

Yesterday we had another total server crash caused by a referer-spammer which accessed the site 200 times in one minute from one IP.

I tried tweaking the MySQL db-settings, and Apache2, but to no avail.

My questions are:

- Does this sound familiar?
- The number of posts in de DB is > 30.000. Could that cause the problem?
- Could switching from MyISAM to InnoDB help?
- Do people here have any experience with Apache/MySQL settings tweaking, as I am at best an amateur.