Advertisement:

Author Topic: Slow DB performance (timeouts and http 500 errors) 2.0 rc3  (Read 1572 times)

Offline gh0stw4lk3r

  • Semi-Newbie
  • *
  • Posts: 39
    • Dutch FZR Owners club
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..
« Last Edit: May 14, 2010, 11:38:08 AM by gh0stw4lk3r »

kat

  • Guest
Re: Slow DB performance (timeouts and http 500 errors)
« Reply #1 on: May 14, 2010, 11:36:37 AM »
i shall have to move to a new host..


That's your best option, by far.  :)

Offline gh0stw4lk3r

  • Semi-Newbie
  • *
  • Posts: 39
    • Dutch FZR Owners club
Re: Slow DB performance (timeouts and http 500 errors) 2.0 rc3
« Reply #2 on: May 15, 2010, 01:47:29 PM »
well, after disabling the "related topics" mod, the execution time for queries went down by seconds....
stupid that i never thought of that before...

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

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
Re: Slow DB performance (timeouts and http 500 errors) 2.0 rc3
« Reply #3 on: May 15, 2010, 01:54:59 PM »
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.