WordPress.org

Ready to get started?Download WordPress

Forums

Server Load Every Time I Add Post (14 posts)

  1. jayo
    Member
    Posted 4 years ago #

    Every time I add a post, our server load shoots through the roof. I think the database insert is messed up for some reason... This is the list of mysql processes that were running as I added a new post...

    Anyone see anything odd?

    ########################################################
    root@server1 [~]# mysqladmin processlist
    +------+------------+-----------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host | db | Command | Time | State
    | Info
    |
    +------+------------+-----------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | 1901 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1904 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1905 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt ON tt.term_id |
    | 1907 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1908 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt ON tt.term_id |
    | 1911 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1913 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1914 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1915 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt ON tt.term_id |
    | 1916 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1917 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1919 | user_blog | localhost | user_wp | Query | 4 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1920 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1921 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1922 | user_blog | localhost | user_wp | Query | 2 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1925 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1926 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1927 | user_blog | localhost | user_wp | Query | 1 |
    Creating tmp table | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN
    wp_term_taxonomy AS tt ON tt.term_id = t.term_id IN |
    | 1929 | user_blog | localhost | user_wp | Query | 4 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1930 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1931 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1932 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1933 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1934 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1935 | user_blog | localhost | user_wp | Query | 2 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1936 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT tt.term_id, tt.term_taxonomy_id FROM wp_terms
    AS t INNER JOIN wp_term_taxonomy as tt ON tt. |
    | 1937 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1938 | user_blog | localhost | user_wp | Query | 4 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1939 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT post_id, meta_key, meta_value FROM wp_postmeta
    WHERE post_id IN (4) |
    | 1940 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT user_id, meta_key, meta_value FROM wp_usermeta
    WHERE user_id IN (1) |
    | 1941 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1942 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1943 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1945 | user_blog | localhost | user_wp | Query | 4 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1946 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1947 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1948 | user_blog | localhost | user_wp | Query | 2 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1950 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1951 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1952 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1953 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1954 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1955 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1956 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1957 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1958 | user_blog | localhost | user_wp | Query | 4 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1959 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1960 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1961 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1962 | user_blog | localhost | user_wp | Sleep | 1 |
    |
    |
    | 1963 | user_blog | localhost | user_wp | Query | 6 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1965 | user_blog | localhost | user_wp | Query | 2 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1966 | user_blog | localhost | user_wp | Query | 5 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1968 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1969 | user_blog | localhost | user_wp | Query | 2 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1970 | user_blog | localhost | user_wp | Query | 4 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1973 | user_blog | localhost | user_wp | Query | 6 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1977 | user_blog | localhost | user_wp | Query | 1 | Opening
    tables | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt ON tt.term_id |
    | 1979 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1980 | user_blog | localhost | user_wp | Query | 3 | Copying
    to tmp table | SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM
    wp_posts INNER JOIN wp_term_relationships ON |
    | 1984 | user_blog | localhost | user_wp | Query | 4 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1985 | user_blog | localhost | user_wp | Query | 3 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1986 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1987 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1988 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1989 | user_blog | localhost | user_wp | Sleep | 3 |
    |
    |
    | 1991 | user_blog | localhost | user_wp | Query | 3 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1992 | user_blog | localhost | user_wp | Query | 3 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1994 | user_blog | localhost | user_wp | Query | 3 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1995 | user_blog | localhost | user_wp | Query | 3 | closing
    tables | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post |
    | 1996 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 1997 | user_blog | localhost | user_wp | Sleep | 3 |
    |
    |
    | 1998 | user_blog | localhost | user_wp | Sleep | 3 |
    |
    |
    | 1999 | user_blog | localhost | user_wp | Sleep | 2 |
    |
    |
    | 2000 | root | localhost | | Query | 0 |
    | show processlist
    |
    +------+------------+-----------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    #################################################

  2. Try decativating all plugins and then make a quick test post. If the load has decreased, reactivate each one individually until you find the cause.

  3. jayo
    Member
    Posted 4 years ago #

    Ok, ill try that. Thanks. Processes look normal to you tho?

  4. jayo
    Member
    Posted 4 years ago #

    Anyone else?

  5. Did you see any load improvement when all of your plugins were deactivated?

  6. ErisDS
    Member
    Posted 4 years ago #

    What version of WordPress are you using, and are you using any heavy plugins like caching?

  7. jayo
    Member
    Posted 4 years ago #

    Im working 3.0... here's the plugin list:

    Adminimize
    Admin Menu Post/Page Counter
    Advanced Category Excluder
    Contact Form 7
    Different Posts Per Page
    Flickr Manager for WP 2.8
    Google News Sitemap
    MobilePress
    PollDaddy Polls
    Really Simple CAPTCHA
    WordPress.com Stats
    WP-PageNavi
    WP Super Cache

  8. Have you tried deactivating all of them yet, and did you see any load improvement while all of your plugins were deactivated?

  9. ErisDS
    Member
    Posted 4 years ago #

    When you deactivate your plugins, try WP Super Cache first ;)

  10. jayo
    Member
    Posted 4 years ago #

    Hey James, yes I did... and same thing. When I entered a new post, the load shot up right after.

  11. Oliver Krautscheid (oliversk)
    Member
    Posted 3 years ago #

    Same problems as OP.

    Thanks for posting the plugin list. Here are the plugins we have in common:

    Advanced Category Excluder
    Contact Form 7
    WordPress.com Stats
    WP-PageNavi
    WP Super Cache

    So.. I really don't want to deactivate any of them, but maybe it's one of them. My server also crashes, becomes totally unresponsive. Heck, I even had to order a remote reboot now.

    This guys here disabled a certain plugin to fix the issue:
    http://www.webhostingtalk.com/showthread.php?t=700720

    Some more suggestions can be found here:
    http://wordpress.org/support/topic/database-error-on-listing-posts-for-category?replies=16

    I tried to repair my tables as well. Might have to compare the indexes.

  12. Oliver Krautscheid (oliversk)
    Member
    Posted 3 years ago #

    Anyone of you using cbnet optimizer? The only plugin that I've added recently.. and it's also related to post publishing :)

    Anyway, I will keep you posted.

  13. Oliver Krautscheid (oliversk)
    Member
    Posted 3 years ago #

    I did a test after disabling cbnet and opened "Add New Post" 5 times instantly.. server load did not go up this time.

    I still think there's a problem somewhere else.. will closely monitor my server and mysql.

    Tip: Also download WP Options Manager and get rid of all the junk that is using autoload. I had like 650 entries, now down to 300.

  14. Oliver Krautscheid (oliversk)
    Member
    Posted 3 years ago #

    I upgraded the plugin WordPress.com Stats. When I imported the stats, server load went up to 50%. Strange, but ok.

    Shortly afterward, server load went up the sky 190+ and server became an unresponsive. Lucky for me, I catched this on my site:
    MySQL server has gone away on line: 124

    This guys has the same problem:
    http://wordpress.org/support/topic/wp-super-cache-mysql-server-has-gone-away-on-line-124

    Actually, I knew Supercache was behind all this, because I had to disable eAccelerator and Ioncube before.

    Anyway.. I'm on to it now. Downloaded the latest supercache and when I activate it server crashes..

Topic Closed

This topic has been closed to new replies.

About this Topic