Support » Fixing WordPress » Server Load Every Time I Add Post

  • 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)
Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Server Load Every Time I Add Post’ is closed to new replies.