- Do you use Antispam plugin, there is an option to block referrer spam?
- Do you ever optimize or empty hitlog, sessions and basedomains tables?

If any of your blogs generates 40-50% of total system traffic you can split the database and move high-traffic blog to another b2evo install

Another solution is get a better server.

Also how much of your main page really needs to be dynamically generated. Here's a hint: how often do you change your linkblog? Perhaps other items in your sidebar are reasonably close to static that it might make more sense to do them in html instead of querying your database?

You're asking the wrong forum for info about wordpress though. Better to ask there if converting will improve your situation or not eh?

Heck maybe it's time to pay for something that can handle the load. I mean, I have no idea what that might be but I play in some forums that are paid software packages instead of open source stuff, so I reckon someone is making money by selling a blog app that can handle multi-blog multi-author multi-lingual situations.

Thanks for your replies!

- Do you use Antispam plugin, there is an option to block referrer spam?
- Do you ever optimize or empty hitlog, sessions and basedomains tables?

No and yes. I will look into the first, but it depends how the system blocks referer spam if this will be effective.
I have set the hitlog to only keep a 4 day history. In what way would emptying the sessions and basedomains-table help? They are not the bottleneck queries...

-If any of your blogs generates 40-50% of total system traffic you can split the database and move high-traffic blog to another b2evo install

No, there are no high traffic posts

- Another solution is get a better server.

Better than a dedicated dual core with 2gb? :-)

- Also how much of your main page really needs to be dynamically generated. Here's a hint: how often do you change your linkblog?

Most of the site that is static (like links, categories etc) are also static html. The linkblog is changed around 2-4 times per day, the newsblog 2-4 times per hour. There are some additional low-traffic pages that come from the db, but they should pose no threat to the server...

btw, the site is http://www.geencommentaar.nl

Update: I do not have the option to give a 403 to referer spammers

Spuyt12 wrote:

Update: I do not have the option to give a 403 to referer spammers

Install the plugin and check the Global settings -> Antispam page, it should be there.

You can also customize the 403 template in skins/_403_referer_spam.main.php

Seems like you're getting good advice so far. How many transactions/day to you get?

Do you have access to the Apache server? If you do you could tune it to retain more data in memory. 2GB is not that much memory anymore.
But as usual it "depends".

Do the referrer spams come from multiple addresses? Or just one? You could block the IP.

Hi Spuyt12,

Have a look at the [url=http://forums.b2evolution.net/viewtopic.php?t=12041]DNS Antispam Trackback[/url] plugin. If it's not exactly what you need there may be a codesnippet that can be modified to your needs.

Good luck

Thanks afwas, I will keep that one in mind. One question about the antispam plugin, however.

How does it identify refererspam? I added a routine to the 403 page that sends me a mail every time that the page is shown, but so far it hasn't send me one :-)

Well, my server keeps crashing, and the anti-spam page has never been used.

So, could someone please answer me question as posted above? How does the plugin identify referer spam?

The situation is sort of desperate. I do not have time to migrate to another blog engine, so I am stuck :-(

Hi Spuyt12,

As soon as possible install this plugin: http://sourceforge.net/project/showfiles.php?group_id=160495&package_id=219132 and enable statistics in the settings. They will show up in Dashboard -> Tools -> DNSBL. Please let me know if it detects and blocks correctly.

Good luck

Personally I detect spam referrers with a few keywords and a regex ... all this is done *before* the evo core kicks in, if they're a spammer they get told where to shove their shit in a < 1Kb page.

¥