Title: Table Memory
Last modified: April 28, 2025

---

# Table Memory

 *  Resolved [mikegraci](https://wordpress.org/support/users/mikegraci/)
 * (@mikegraci)
 * [11 months, 2 weeks ago](https://wordpress.org/support/topic/table-memory/)
 * Hi
 * I am renaming many posts and also deleting users and renaming permalinks. I keep
   checking the table memory. Would appreciate your feedback.
 * I started at 113MB renamed 2 posts, deleted 2 users and created 2 new users. 
   24 hours later I see the table size grew by 6MB to 119. I was not expecting it
   to grow at all.
 * Will the table size grow with these changes? Is the growth permanent?. Also, 
   it seems to take 24 hours for the memory to change, after I do these operations
   does that make sense?
 * Screen shot before and after changes….. [https://share.zight.com/E0uB4WXk](https://share.zight.com/E0uB4WXk)
   [https://share.zight.com/v1uz444g](https://share.zight.com/v1uz444g)
 * Appreciate comments.
 * Thanks
 * Mike
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftable-memory%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [Damilare](https://wordpress.org/support/users/deabiodun/)
 * (@deabiodun)
 * [11 months, 2 weeks ago](https://wordpress.org/support/topic/table-memory/#post-18441081)
 * Hi Mike!
   The increase in database size is expected given how WordPress works.
   For example, updating a post (including renaming it) leads to the creation of
   post revisions which are saved as new rows in the relevant database table. Likewise,
   deleting a user may leave behind related data like comments, postmeta, usermeta
   and other relevant information. Scheduled actions may also be created against
   a future date, thus causing some data to only be permanently removed at a later
   time.
 * There are many other potential reasons for such database size increase and a 
   quick Google search will definitely provide relevant results.
 * Feel free to get in touch if you have any further concerns pertaining to the 
   WPO plugin.
 * Kind regards.
 *  Thread Starter [mikegraci](https://wordpress.org/support/users/mikegraci/)
 * (@mikegraci)
 * [11 months, 2 weeks ago](https://wordpress.org/support/topic/table-memory/#post-18441605)
 * Thanks Damilare for response.
 * Just want to clarify. When I run the full optimization..it doesn’t lower the 
   number….are you saying that over time the memory “will be freed up” and subsequent
   Optimization runs will eventually reduce the total memory count?
 * Thanks
 *  Plugin Support [Damilare](https://wordpress.org/support/users/deabiodun/)
 * (@deabiodun)
 * [11 months, 2 weeks ago](https://wordpress.org/support/topic/table-memory/#post-18442857)
 * Running full optimization does not necessarily mean space will be freed instantly
   all the time. This is largely dependent on MySQL storage engine behavior.
 * For example, deleting a row of data in an InnoDB table may still retain allocated
   space for some time until the table shrinks when the OPTIMIZE TABLE sql query
   is run either manually or at a scheduled time.
 * Also, the amount of data optimized each time may not be significant enough (a
   few kilobytes) to reflect in your monitoring endeavors.
 * In any case, WPO database optimization feature will always do its job in its 
   optimization operations provided there is something to optimize, as listed in
   the optimization table.
 * Kind regards.

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

The topic ‘Table Memory’ is closed to new replies.

 * ![](https://ps.w.org/wp-optimize/assets/icon-256x256.png?rev=1552899)
 * [WP-Optimize – Cache, Compress images, Minify & Clean database to boost page speed & performance](https://wordpress.org/plugins/wp-optimize/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-optimize/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-optimize/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-optimize/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-optimize/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-optimize/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Damilare](https://wordpress.org/support/users/deabiodun/)
 * Last activity: [11 months, 2 weeks ago](https://wordpress.org/support/topic/table-memory/#post-18442857)
 * Status: resolved