WordPress.org

1. rushza
   Member
   Posted 4 years ago #

   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.

2. Kafkaesqui
   Moderator
   Posted 4 years ago #

   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?

3. rushza
   Member
   Posted 4 years ago #

   yes I am

   http://wordpress.org/extend/plugins/simple-tags

   could that be a problem ?

4. Kafkaesqui
   Moderator
   Posted 4 years ago #

   It's a place to start, for sure.

5. rushza
   Member
   Posted 4 years ago #

   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 :-)

6. Kafkaesqui
   Moderator
   Posted 4 years ago #

   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.

7. rushza
   Member
   Posted 4 years ago #

   That is probably the best course of action.

   Thank you so much for your time :-)

Topic Closed

This topic has been closed to new replies.