Title: Large overhead
Last modified: August 21, 2016

---

# Large overhead

 *  Resolved [NOT-IN-USE-DELETE](https://wordpress.org/support/users/rogerwheatley/)
 * (@rogerwheatley)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/large-overhead/)
 * What can we do to fix the large database overhead each rule costs?
    For example,
   creating one rule causes the following:
 * **Table:**
    wp_psn_rules
 * **Table Records:**
    1
 * **Data Usage:**
    16.0 KiB
 * **Index Usage:**
    0
 * **Overhead:**
    6.0 MiB
 * In essence, it appears there’s a 6MB overhead for a single 16KB record.
 * Any assistance would be greatly appreciated! 🙂
 * [http://wordpress.org/plugins/post-status-notifier-lite/](http://wordpress.org/plugins/post-status-notifier-lite/)

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

 *  Plugin Author [Timo](https://wordpress.org/support/users/worschtebrot/)
 * (@worschtebrot)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/large-overhead/#post-4157691)
 * Hi Roger,
    thanks for your feedback. I’ll check this on my test servers and give
   you a reply. Any more information would be great (eg screenshots). Please use
   the contact or support form on [http://www.ifeelweb.de/contact/](http://www.ifeelweb.de/contact/)
   Thanks
 *  Plugin Author [Timo](https://wordpress.org/support/users/worschtebrot/)
 * (@worschtebrot)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/large-overhead/#post-4157818)
 * I did some research and can not find any negative aspect about this. Eg all the
   tables on my dev WP installation have a “Data_free” value of 6291456, including
   the psn_rules table.
    You get those data with SQL “SHOW TABLE STATUS” (see [http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html](http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html))
 * Only phpMyAdmin calls this value “overhead” which sounds kind of bad.
 * [http://stackoverflow.com/questions/1288573/how-much-table-overhead-is-too-much](http://stackoverflow.com/questions/1288573/how-much-table-overhead-is-too-much):
   “
   Overhead” is not yet reclaimed space formerly occupied by now deleted records.
   If you’re doing a lot of inserts / deletes, it’s pretty much always going to 
   be there.

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

The topic ‘Large overhead’ is closed to new replies.

 * ![](https://ps.w.org/post-status-notifier-lite/assets/icon-128x128.png?rev=971663)
 * [Post Status Notifier Lite](https://wordpress.org/plugins/post-status-notifier-lite/)
 * [Support Threads](https://wordpress.org/support/plugin/post-status-notifier-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/post-status-notifier-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/post-status-notifier-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/post-status-notifier-lite/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Timo](https://wordpress.org/support/users/worschtebrot/)
 * Last activity: [12 years, 8 months ago](https://wordpress.org/support/topic/large-overhead/#post-4157818)
 * Status: resolved