WordPress.org

Ready to get started?Download WordPress

Forums

help with database overload (2 posts)

  1. Scytle
    Member
    Posted 7 years ago #

    Does anyone know what these sort of query's mean?

    SELECT * FROM wp_users WHERE ID = '229' LIMIT 1
    SELECT * FROM wp_users WHERE ID = '155' LIMIT 1
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = '191'
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = '191'
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = '155'
    SELECT * FROM wp_users WHERE ID = '127' LIMIT 1
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = '127'
    SELECT * FROM wp_users WHERE ID = '118' LIMIT 1
    SELECT * FROM wp_users WHERE ID = '223' LIMIT 1
    SELECT COUNT(*) FROM wp_posts WHERE post_author = '251' AND post_type = 'post' AND post_status = 'pu
    SELECT * FROM wp_comments WHERE comment_post_ID = '334' AND comment_approved = '1' ORDER BY comment_
    SELECT option_value FROM wp_options WHERE option_name = 'len' LIMIT 1
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.p
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_p
    SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(2097,2096,2089,2085,2082,2072
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_p
    INSERT INTO wp_comments
    SELECT comment_date_gmt FROM wp_comments WHERE comment_author_IP = '84.179.52.20' OR comment_author_
    SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(1583) ORDER BY post_id, meta_
    INSERT INTO wp_comments
    SELECT option_value FROM wp_options WHERE option_name = 'ec3_day_length' LIMIT 1
    SELECT option_value FROM wp_options WHERE option_name = 'ec3_num_months' LIMIT 1

    I am pretty weak when it comes to sql, but to me it looks like I am being spammed by someone trying to do something. Perhaps post a lot of comments/posts? should i turn off user registration and clear out extra accounts? would bad behavior help? I need to get my concurrent query load below 15 at a time or my host will keep turning off my cgi.
    would upgrding to 2.2 help at all?

    running wordpress 2.1
    have wp-cache installed

    Bah humbug.

  2. Scytle
    Member
    Posted 7 years ago #

    anyone? I would really appreciate some help on this.

Topic Closed

This topic has been closed to new replies.

About this Topic