Title: Server load, tmp writes
Last modified: August 20, 2016

---

# Server load, tmp writes

 *  [rezag](https://wordpress.org/support/users/rezag/)
 * (@rezag)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/server-load-tmp-writes/)
 * On a rather popular site the host is asking us to investigate constant tmp writes
   that is increasing load on the server often. General my.cnf, php.ini (changing
   memory value, max packet value, etc.) have made little difference. Any ideas 
   on how to manage/decrease these? Thanks
 * Example:
 * Copying to tmp table | SELECT p.ID AS ‘id’, p.post_title AS ‘title’, p.post_date
   AS ‘date’, p.post_author AS ‘uid’ , ( IFNULL(v.pageviews, 0)/(IF ( DATEDIFF(‘
   2013-01-13 10:45:53’, MIN(v.day)) > 0, DATEDIFF(‘2013-01-13 10:45:53’, MIN(v.
   day)), 1) )) AS ‘avg_views’ FROM ******_posts p LEFT JOIN (SELECT id, SUM(pageviews)
   AS ‘pageviews’, day FROM (SELECT id, pageviews, day FROM ******_popularpostsdatacache
   WHERE day > DATE_SUB(‘2013-01-13 10:45:53’, INTERVAL 1 WEEK) ORDER BY day) sv
   GROUP BY id) v ON p.ID = v.id WHERE p.post_status = ‘publish’ AND p.post_password
   = ” AND p.post_type IN(‘post’,’page’) GROUP BY p.ID HAVING avg_views > 0.0000
   ORDER BY avg_views DESC LIMIT 5 |
 * Using latest version
    [http://wordpress.org/extend/plugins/wordpress-popular-posts/](http://wordpress.org/extend/plugins/wordpress-popular-posts/)

Viewing 1 replies (of 1 total)

 *  [Jay Smooth](https://wordpress.org/support/users/jsmooth1200/)
 * (@jsmooth1200)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/server-load-tmp-writes/#post-3490744)
 * We’re experiencing the same problem and I’ve posted [here](http://wordpress.org/support/topic/mysql-query-performance-issues).
   Hopefully we hear back about some possible solutions or a fix soon!

Viewing 1 replies (of 1 total)

The topic ‘Server load, tmp writes’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-popular-posts/assets/icon-256x256.png?rev=1232659)
 * [WP Popular Posts](https://wordpress.org/plugins/wordpress-popular-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-popular-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-popular-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-popular-posts/reviews/)

## Tags

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

 * 1 reply
 * 2 participants
 * Last reply from: [Jay Smooth](https://wordpress.org/support/users/jsmooth1200/)
 * Last activity: [12 years, 12 months ago](https://wordpress.org/support/topic/server-load-tmp-writes/#post-3490744)
 * Status: not resolved