Database issues

  • After 8 years, I have more than 20,000 posts and 12,200 comments (at one time I was ranked the top single-person blogger). It appears, though I am not certain, that the database now places too much demand on the server and I get mysql_slow_queries around the clock (with currently just 300 page views/day). I am also getting pretty consistent cpu throttling. I don’t believe I am placing any unusual demands on the server with plugins, etc. My questions: Is it time to split the blog and start fresh, and if so, what would you recommend? Or is there a simpler solution I am overlooking? The database is 31MB (62 with indexes).

Viewing 1 replies (of 1 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Try caching, first. You can do wonders with DB caching as well as file caching.

    WP Super Cache and W3 Total Cache are good.

Viewing 1 replies (of 1 total)
  • The topic ‘Database issues’ is closed to new replies.