admin管理员组

文章数量:1312957

I have used Media Cleaner Pro Plugin to clean few batches of registered images. Additionally i have updated my functions.php so these unused images will not be generated in future.

function wpse_unset_images( $sizes ){
unset( $sizes[ 'medium_large' ] );
unset( $sizes[ 'large' ]);
unset( $sizes[ 'member-two' ] );
unset( $sizes[ 'member' ] );
unset( $sizes[ 'shop_thumbnail' ]);
unset( $sizes[ 'woocommerce_gallery_thumbnail' ] );
unset( $sizes[ 'widget-thumb-medium' ] );
return $sizes; 
}
add_filter( 'intermediate_image_sizes_advanced', 'wpse_unset_images' );

I can clearly see the visible difference in my web space which has reduced from 7GB to 4GB and also indoes has come down to half from almost 300,000 to 1,70,000.

But i have seen that there is no difference in DB size. It means plugin has NOT removed required rows/data from database. Database size is still 350MB.

I have around 12K products, but having almost

  • 700,000 rows in wp_postmeta
  • 40K rows in wp_posts

I need some guidance to clean/optimize database using SQL to remove data related to removed images.

NOTE* - Additional rows in DB may also be due to fact that i updated product prices in BULK for almost 12K products twice. I need to clear that mess also.

本文标签： pluginsOptimise wordpress database using SQL after deleting registered images from Media Folder

版权声明：本文标题：plugins - Optimise wordpress database using SQL after deleting registered images from Media Folder 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741906129a2404156.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。