Title: Optimization problems, slow Mysql queries
Last modified: August 19, 2016

---

# Optimization problems, slow Mysql queries

 *  [mpromptu](https://wordpress.org/support/users/mpromptu/)
 * (@mpromptu)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/optimization-problems-slow-mysql-queries/)
 * I can’t log into my WordPress admin right now because my account has been suspended…
   when I called Bluehost (my server), they said the server was getting hit too 
   many times by slow queries and I needed to optimize something… (I wasn’t sure
   what they were talking about). They did have me get the mysql_slow_queries folder
   and I have a lot of things that look like this:
 * # Sat Mar 1 06:33:27 2008
    # Query_time: 2 Lock_time: 0 Rows_sent: 10 Rows_examined:
   88104 use friendl5_wrdp1; SELECT DISTINCT wp_comments.* FROM wp_comments LEFT
   JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status =‘
   publish’ OR post_status = ‘static’) AND comment_approved= ‘1’ AND post_password
   = ” AND comment_type = ” ORDER BY comment_date DESC LIMIT 10
 * Can someone please help me fix this and get my account back?

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

 *  [bernardborealis](https://wordpress.org/support/users/bernardborealis/)
 * (@bernardborealis)
 * [17 years, 10 months ago](https://wordpress.org/support/topic/optimization-problems-slow-mysql-queries/#post-796771)
 * This is most commonly caused by poor, or lack of indexing. When you have a field
   with a very large amount of entries and a query takes a long time to browse it
   for what it is looking for, this may result in extra CPU time. If you set up 
   an index for that field, it will make it much easier for the query to find what
   it is looking for and you’ll avoid a lot of CPU usage that way. (you can do this
   through phpmyadmin)
 *  [moshu](https://wordpress.org/support/users/moshu/)
 * (@moshu)
 * [17 years, 10 months ago](https://wordpress.org/support/topic/optimization-problems-slow-mysql-queries/#post-796772)
 * Bernard, STOP digging up months old post that are mentioning bluehost!

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

The topic ‘Optimization problems, slow Mysql queries’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [moshu](https://wordpress.org/support/users/moshu/)
 * Last activity: [17 years, 10 months ago](https://wordpress.org/support/topic/optimization-problems-slow-mysql-queries/#post-796772)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics