Title: Change request – remove "DELAYED" inserts
Last modified: August 20, 2016

---

# Change request – remove "DELAYED" inserts

 *  [RedKrieg](https://wordpress.org/support/users/redkrieg/)
 * (@redkrieg)
 * [14 years, 9 months ago](https://wordpress.org/support/topic/change-request-remove-delayed-inserts/)
 * “DELAYED” inserts in shared hosting environments often cause MySQL to drastically
   increase CPU usage due to the way it handles these requests. A normal insert 
   takes slightly longer to return, but overall resource usage for the system is
   drastically less than with the “DELAYED” keyword. The MySQL documentation (found
   here [http://dev.mysql.com/doc/refman/5.5/en/insert-delayed.html](http://dev.mysql.com/doc/refman/5.5/en/insert-delayed.html))
   has this to say about using DELAYED inserts:
 * >  Note that INSERT DELAYED is slower than a normal INSERT if the table is not
   > otherwise in use. There is also the additional overhead for the server to handle
   > a separate thread for each table for which there are delayed rows. This means
   > that you should use INSERT DELAYED only when you are really sure that you need
   > it.
 * Please consider changing this behavior in your plugin, as right now my best advice
   for users causing problems with this is to tell them to discontinue use of your
   plugin.

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

 *  [Jason Crouse](https://wordpress.org/support/users/coolmann/)
 * (@coolmann)
 * [14 years, 9 months ago](https://wordpress.org/support/topic/change-request-remove-delayed-inserts/#post-2276070)
 * You may want to take a look at my plugin instead 😉 It’s optimised for best db
   performance, it uses both myisam and innodb, and doesn’t have delayed inserts.
 * [http://wordpress.org/extend/plugins/wp-slimstat/](http://wordpress.org/extend/plugins/wp-slimstat/)
 * Cheers,
    Camu
 *  Plugin Contributor [helened](https://wordpress.org/support/users/helened/)
 * (@helened)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/change-request-remove-delayed-inserts/#post-2276243)
 * Thank you for alerting us to this issue with “delayed insert” on shared servers.“
   Delayed Insert” has improved WassUp’s performance since it was added over 2 years
   ago, but we were unaware that it had any significant adverse affect on the overall
   performance of shared servers. Once we have verified this, we will change WassUp
   code to remove this as a default settings and turn it into a performance improvement
   option only for users on dedicated servers.

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

The topic ‘Change request – remove "DELAYED" inserts’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wassup_f2eef0.svg)
 * [WassUp Real Time Analytics](https://wordpress.org/plugins/wassup/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wassup/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wassup/)
 * [Active Topics](https://wordpress.org/support/plugin/wassup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wassup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wassup/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [helened](https://wordpress.org/support/users/helened/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/change-request-remove-delayed-inserts/#post-2276243)
 * Status: not resolved