Title: SQL Database Tidy – Smush
Last modified: June 25, 2022

---

# SQL Database Tidy – Smush

 *  Resolved [oriver](https://wordpress.org/support/users/oriver/)
 * (@oriver)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/sql-database-tidy-smush/)
 * Hi,
 * I’m currently conducting a clean up of the SQL database and was deleting old 
   remnants of a previous plugin; Smush that we used before yourselves, however 
   I’m aware that WPOptimize uses resmush.it. Therefore I just wanted to check before
   continuing if you use the following:
 * meta-key:
    smush-complete smush-info smush-marked smush-stats wp-smpro-smush-
   data
 * wp-smush-resize_sizes
 * Thank you

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

 *  Plugin Contributor [Venkat Raj](https://wordpress.org/support/users/webulous/)
 * (@webulous)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/sql-database-tidy-smush/#post-15769354)
 * Hi [@oriver](https://wordpress.org/support/users/oriver/)
 * Thanks for using our plugin.
    Yes, we use following meta key to store compression
   data in `postmeta` table. smush-complete smush-info smush-marked smush-stats
 * Following are not used:
    wp-smpro-smush-data wp-smush-resize_sizes
 * Meta value for `smush-info` always ends with `using WP-Optimize`
 * Meta value for `smush-stats` will have something like `a:5:{s:12:"smushed-with";
   s:11:"re-smush-it";s:13:"original-size";i:117556;s:12:"smushed-size";i:72925;
   s:15:"savings-percent";d:37.97;s:10:"sizes-info";a:6:{s:4:"full";a:2:{s:8:"original";
   i:117556;s:10:"compressed";i:72925;}s:6:"medium";a:2:{s:8:"original";i:9648;s:
   10:"compressed";i:8275;}s:5:"large";a:2:{s:8:"original";i:47706;s:10:"compressed";
   i:41647;}s:9:"thumbnail";a:2:{s:8:"original";i:4795;s:10:"compressed";i:4004;}
   s:12:"medium_large";a:2:{s:8:"original";i:32330;s:10:"compressed";i:28448;}s:
   9:"1536x1536";a:2:{s:8:"original";i:82451;s:10:"compressed";i:70608;}}}`
 *  Thread Starter [oriver](https://wordpress.org/support/users/oriver/)
 * (@oriver)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/sql-database-tidy-smush/#post-15771713)
 * Hi [@webulous](https://wordpress.org/support/users/webulous/)
 * That’s great thank you so much.
 * It seems we’re missing “wp-optimize-show_smush_metabox” & “wp-optimize-autosmush”&“
   skip-smush-setup” which could have been from a previous developer tidying up 
   for us. It seems to all be working, but if this is needed or other rows have 
   been deleted, if we deactivate, delete and reinstall the plugin would it reinstall
   any missing rows?
 *  [Harshad](https://wordpress.org/support/users/bornforphp/)
 * (@bornforphp)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/sql-database-tidy-smush/#post-15772655)
 * [@oriver](https://wordpress.org/support/users/oriver/) Yes re-installing the 
   plugin will re-install the missing tables,
 *  Thread Starter [oriver](https://wordpress.org/support/users/oriver/)
 * (@oriver)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/sql-database-tidy-smush/#post-15775442)
 * [@bornforphp](https://wordpress.org/support/users/bornforphp/) That’s fantastic,
   thank you.

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

The topic ‘SQL Database Tidy – Smush’ 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/)

 * 4 replies
 * 3 participants
 * Last reply from: [oriver](https://wordpress.org/support/users/oriver/)
 * Last activity: [3 years, 11 months ago](https://wordpress.org/support/topic/sql-database-tidy-smush/#post-15775442)
 * Status: resolved