Title: Object cache: high mysql cpu usage
Last modified: December 20, 2018

---

# Object cache: high mysql cpu usage

 *  [DreamOn11](https://wordpress.org/support/users/dreamon11/)
 * (@dreamon11)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/object-cache-high-mysql-cpu-usage/)
 * Hi,
 * Since many days (I don’t know when exactly), there is a problem with object cache
   setting.
 * When I enable object cache (with disk or memcached), mysql processes CPU usage
   explode, all cores are 100% usage.
 * Formerly, it works fine but today, I cannot enable object cache anymore because
   the website become unusable.
 * Have you got an idea?
 * Configuration:
    – WordPress 5.0.2 – PHP 7.3.0 – MySQL 15.1 Distrib 10.3.11-MariaDB–
   Nginx 1.15.7
 * Thanks.

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

 *  Plugin Contributor [Marko Vasiljevic](https://wordpress.org/support/users/vmarko/)
 * (@vmarko)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/object-cache-high-mysql-cpu-usage/#post-11013112)
 * Hello [@dreamon11](https://wordpress.org/support/users/dreamon11/),
 * Can you please check and share which queries are causing this?
 *  Thread Starter [DreamOn11](https://wordpress.org/support/users/dreamon11/)
 * (@dreamon11)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/object-cache-high-mysql-cpu-usage/#post-11014626)
 * Hello [@vmarko](https://wordpress.org/support/users/vmarko/),
 * Thanks for help.
 * No much info about it: :/
 *     ```
       MariaDB [(none)]> show processlist;
       +--------+-----------------+-----------+----------------------------+---------+------+----------------+-------------------------------------------------------------------------+----------+
       | Id     | User            | Host      | db                         | Command | Time | State          | Info                                                                    | Progress |
       +--------+-----------------+-----------+----------------------------+---------+------+----------------+-------------------------------------------------------------------------+----------+
       | 237015 | xxx | localhost | xxx_production | Sleep   |   12 |                | NULL                                                                    |    0.000 |
       | 237024 | xxx | localhost | xxx_production | Sleep   |    6 |                | NULL                                                                    |    0.000 |
       | 237030 | xxx | localhost | xxx_production | Sleep   |   37 |                | NULL                                                                    |    0.000 |
       | 237039 | xxx | localhost | xxx_production | Sleep   |    1 |                | NULL                                                                    |    0.000 |
       | 237059 | xxx | localhost | xxx_production | Sleep   |   37 |                | NULL                                                                    |    0.000 |
       | 237070 | xxx | localhost | xxx_production | Sleep   |   32 |                | NULL                                                                    |    0.000 |
       | 237076 | xxx | localhost | xxx_production | Sleep   |   24 |                | NULL                                                                    |    0.000 |
       | 237079 | xxx | localhost | xxx_production | Sleep   |   22 |                | NULL                                                                    |    0.000 |
       | 237083 | xxx | localhost | xxx_production | Sleep   |   20 |                | NULL                                                                    |    0.000 |
       | 237102 | xxx | localhost | xxx_production | Sleep   |   12 |                | NULL                                                                    |    0.000 |
       | 237105 | xxx | localhost | xxx_production | Sleep   |    6 |                | NULL                                                                    |    0.000 |
       | 237109 | xxx | localhost | xxx_production | Sleep   |    8 |                | NULL                                                                    |    0.000 |
       | 237111 | xxx | localhost | xxx_production | Sleep   |    5 |                | NULL                                                                    |    0.000 |
       | 237115 | xxx | localhost | xxx_production | Query   |    1 | Writing to net | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' |    0.000 |
       | 237116 | xxx | localhost | NULL                       | Query   |    0 | Init           | show processlist                                                        |    0.000 |
       +--------+-----------------+-----------+----------------------------+---------+------+----------------+-------------------------------------------------------------------------+----------+
       ```
   
 *  Thread Starter [DreamOn11](https://wordpress.org/support/users/dreamon11/)
 * (@dreamon11)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/object-cache-high-mysql-cpu-usage/#post-11014691)
 * Also, many of these errors with memcached:
 * `Dec 20 23:28:27 xxx memcached[17894]: Failed to write, and not due to blocking:
   Broken pipe`

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

The topic ‘Object cache: high mysql cpu usage’ is closed to new replies.

 * ![](https://ps.w.org/w3-total-cache/assets/icon-256x256.png?rev=1041806)
 * [W3 Total Cache](https://wordpress.org/plugins/w3-total-cache/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/w3-total-cache/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/w3-total-cache/)
 * [Active Topics](https://wordpress.org/support/plugin/w3-total-cache/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/w3-total-cache/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/w3-total-cache/reviews/)

## Tags

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

 * 3 replies
 * 2 participants
 * Last reply from: [DreamOn11](https://wordpress.org/support/users/dreamon11/)
 * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/object-cache-high-mysql-cpu-usage/#post-11014691)
 * Status: not resolved