WordPress.org

Forums

Overloading server / WP consultant? (2 posts)

  1. krez
    Member
    Posted 4 years ago #

    I've been running a blog on WordPress for the past 3 years. Our blog has grown in popularity gradually over that time to the point where we've had to move hosting companies several times. Now, at over 20,000 uniques daily, server costs are becoming outrageous and the server becomes very slow or even unresponsive during peak traffic hours.

    I'm posting to see if anyone has any tips for how to alleviate server stress. There's the obvious "less plugins" answer, but I'm at the point where all the plugins I still have are essential to the site's functionality.

    Has anyone had similar problems? Any tips?

    I'd also be willing to explore the idea of hiring a "WordPress Consultant" to help optimize my site, if anyone has any recommendations...

    Thanks.

    Ben

  2. Sounds like you need to work on cleaning up your database: delete post revisions, remove old options, optimize , etc. That's one of the first places to start. Backup your DB being doing anything. Check for huge tables added by stats and loggng plugins.

    Run as SQL query in phpmyadmin to delete revisions:

    DELETE a,b,c
    FROM wp_posts a
    LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
    LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
    WHERE a.post_type = 'revision'

    Then use phpmyadmin to optimize the DB.

    You can add to wp-config.php to stop revisions and autosave:

    define ('WP_POST_REVISIONS', FALSE);
    define('AUTOSAVE_INTERVAL', 6000);

    or select the number of revisions to keep:

    define('WP_POST_REVISIONS', 3);

Topic Closed

This topic has been closed to new replies.

About this Topic