mysql load problems?

  • Hello there

    I would really appreciate some assistance with a small problem I am having.

    My host (dreamhost) is complaining because of my blog, apparently its causing major strain on the mysql server.

    they sent me a mail saying that I should look at the following query;


    # Query_time: 1 Lock_time: 0 Rows_sent: 200 Rows_examined: 35062

    SELECT t.*, tt.*

    FROM wp_terms AS t

    INNER JOIN wp_term_taxonomy AS tt ON t.term_id =
    tt.term_id

    INNER JOIN wp_term_relationships AS tr ON
    tt.term_taxonomy_id = tr.term_taxonomy_id

    INNER JOIN wp_posts AS p ON tr.object_id = p.ID

    WHERE tt.taxonomy IN ( ‘post_tag’ )

    AND p.post_date_gmt < ‘2008-02-15 12:32:31’

    AND tt.count > 0

    GROUP BY t.term_id

    ORDER BY RAND()

    LIMIT 200;

    unfortunately my mysql is pretty bad, I am hoping someone can assist me and tell me what the problem might be?

    Thanks in advance, I really appreciate it.

Viewing 6 replies - 1 through 6 (of 6 total)

  • Nothing related to post tags in WordPress performs a RAND() on the sort order (that I’m aware of). Are you using any tag-related plugins?

    Thread Starter rushza

    (@rushza)

    yes I am

    https://www.ads-software.com/extend/plugins/simple-tags

    could that be a problem ?

    It’s a place to start, for sure.

    Thread Starter rushza

    (@rushza)

    ok, but what would I be looking for?

    as I pointed out, my mysql is not good at all and I don’t know what to be looking for.

    Thanks ??

    My point was, you stated your host is complaining that query is causing a strain on their mysql server. If you were to *turn off the plugin* temporarily, does this both remove the query, and affect the ‘strain’ they’re seeing?

    Beyond that you can contact the plugin developer and ask if that is a query the plugin might be generating, and if it is, have they heard from others having problems with it bogging down mysql.

    Thread Starter rushza

    (@rushza)

    That is probably the best course of action.

    Thank you so much for your time ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘mysql load problems?’ is closed to new replies.

Tags