Title: High Mysql usage
Last modified: June 10, 2018

---

# High Mysql usage

 *  [shahzaibcb](https://wordpress.org/support/users/shahzaibcb/)
 * (@shahzaibcb)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/high-mysql-usage/)
 * Hi,
 * We’re running wordpress sites with around 350G MYISAM and 2G INNODB MYSQL DATA.
   We’re seeing lot of SELECT * queries for wp_posts which are putting mysql usage
   to very high and resulting in node crash. Can anybody please help on how can 
   we reduce queries load ? Here is the attached list of running queries :
 * [https://pastebin.com/cy1iVpQt](https://pastebin.com/cy1iVpQt)
 * My point is, are these queries optimized by wordpress because queries with (*)
   are bad written queries which scans the whole table.
 * Awaiting your response.
 * Regards.

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

 *  [Joey](https://wordpress.org/support/users/leglesslizard/)
 * (@leglesslizard)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/high-mysql-usage/#post-10383766)
 * Hi,
 * Are you using query monitor? This is a plugin that will show you all queries 
   on the page, their speed, highlight any slow ones and show you where they are
   being used. I’d have a look at that and remove any extensions that are running
   slow queries unless they are essential to the site (maybe look at alternatives
   or contact the developers to make them aware of the slow queries)
 *  [te_taipo](https://wordpress.org/support/users/te_taipo/)
 * (@te_taipo)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/high-mysql-usage/#post-10384974)
 * [@shahzaibcb](https://wordpress.org/support/users/shahzaibcb/) How to these correlate
   to your log files, are these activities from your site users, admins, editors
   etc?

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

The topic ‘High Mysql usage’ 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: [te_taipo](https://wordpress.org/support/users/te_taipo/)
 * Last activity: [7 years, 11 months ago](https://wordpress.org/support/topic/high-mysql-usage/#post-10384974)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics