Slow DB performance (timeouts and http 500 errors) 2.0 rc3

Started by gh0stw4lk3r, May 14, 2010, 11:28:19 AM

Previous topic - Next topic

gh0stw4lk3r

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..

kat


gh0stw4lk3r

well, after disabling the "related topics" mod, the execution time for queries went down by seconds....
stupid that i never thought of that before...

Adish - (F.L.A.M.E.R)

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.

Advertisement: