our forum has grown to a 500.000 posts with 10.000 pageviews a day.
we are on a shared host with very few options to tweak the database. resulting in a website that is sometimes unreachable when someone is trying to search the forum.
i can't even create a fulltext or custom index to search because the DB will overload :(
does anyone have any idea what we can do to make our forum more responsive?
status.php:
http://www.fzrclub.nl/smf/status.php
if nothing can be done to optimize our forum i shall have to move to a new host..
Quote from: gh0stw4lk3r on May 14, 2010, 11:28:19 AMi shall have to move to a new host..
That's your best option, by far. :)
well, after disabling the "related topics" mod, the execution time for queries went down by seconds....
stupid that i never thought of that before...
You seem to be hitting the Max CPU usage set by your host. This is when 500 internal server errors start to come up randomly. I see you have disabled related topics mod. It will certainly help as every topic you view, it executes a command causing the db to slow down.