Having trouble with Wordpress DB

Discussion in 'WordPress' started by dpsubi1, Oct 16, 2009.

  1. #1
    I have a wordpress blog related to health niche and have 5000+ posts and 12000+ tags and 50 categories.

    The blog worked great untill a month back. Now, whenever I update my old posts or access old posts, the mysql usage goes to 100% for few mins then works. Because of high CPU usage my host blocks my account. There is no resource issue if I create a new post or view new posts. The problem is with old posts only.

    I also did DB optimization, exported the DB and imported to new DB, changing themes, disabling plugins, etc. but the problem is not resolved.

    Anyone have had experience like this ? would love to hear your suggestions.:)

    Using latest WP versions, latest version of plugins.
     
    dpsubi1, Oct 16, 2009 IP