Title: mysql load problems?
Last modified: August 19, 2016

---

# mysql load problems?

 *  [rushza](https://wordpress.org/support/users/rushza/)
 * (@rushza)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/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)

 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697642)
 * 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](https://wordpress.org/support/users/rushza/)
 * (@rushza)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697662)
 * yes I am
 * [http://wordpress.org/extend/plugins/simple-tags](http://wordpress.org/extend/plugins/simple-tags)
 * could that be a problem ?
 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697712)
 * It’s a place to start, for sure.
 *  Thread Starter [rushza](https://wordpress.org/support/users/rushza/)
 * (@rushza)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697745)
 * 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 🙂
 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697760)
 * 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](https://wordpress.org/support/users/rushza/)
 * (@rushza)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697768)
 * 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

 * [load](https://wordpress.org/support/topic-tag/load/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Developing with WordPress](https://wordpress.org/support/forum/wp-advanced/)
 * 6 replies
 * 2 participants
 * Last reply from: [rushza](https://wordpress.org/support/users/rushza/)
 * Last activity: [18 years, 3 months ago](https://wordpress.org/support/topic/mysql-load-problems/#post-697768)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics