Server Load Every Time I Add Post

  • jayo

    (@jayo)


    13 years, 9 months 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
    |
    +——+————+———–+———–+———+——+———————-+——————————————————————————————————+
    #################################################

Viewing 13 replies - 1 through 13 (of 13 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    13 years, 9 months ago

    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.

    Thread Starter jayo

    (@jayo)

    13 years, 9 months ago

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

    Thread Starter jayo

    (@jayo)

    13 years, 9 months ago

    Anyone else?

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    13 years, 9 months ago

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

    ErisDS

    (@erisds)

    13 years, 9 months ago

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

    Thread Starter jayo

    (@jayo)

    13 years, 9 months 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

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    13 years, 9 months ago

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

    ErisDS

    (@erisds)

    13 years, 9 months ago

    When you deactivate your plugins, try WP Super Cache first 😉

    Thread Starter jayo

    (@jayo)

    13 years, 9 months ago

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

    Oliver Krautscheid (oliversk)

    (@soliver)

    13 years, 6 months 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.

    Oliver Krautscheid (oliversk)

    (@soliver)

    13 years, 6 months 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.

    Oliver Krautscheid (oliversk)

    (@soliver)

    13 years, 6 months 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.

    Oliver Krautscheid (oliversk)

    (@soliver)

    13 years, 6 months 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..

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Server Load Every Time I Add Post’ is closed to new replies.