How to reduce amount of image sizes stored in DB
-
Hello,
I have a database table with a size of 10GB (wp_postmeta), and the reason is mostly because of Media Cloud saving all the image sizes into “_wp_attachment_metadata”, in the meta_value column. I only want to save some specific sizes, and not all of them.
I have over more then 70K products with 5+ images per product. Below code is attached at each image, and I need to reduce it to just only 2 image sizes. Please help me get this done. Thanks.
a: 6: { s: 5: "width"; i: 1929; s: 6: "height"; i: 79; s: 4: "file"; s: 39: "2019/06/drGvNCCD-graphic05-free-img.png"; s: 5: "sizes"; a: 13: { s: 6: "medium"; a: 5: { s: 4: "file"; s: 29: "graphic05-free-img-300x12.png"; s: 5: "width"; i: 300; s: 6: "height"; i: 12; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-300x12.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 5: "large"; a: 5: { s: 4: "file"; s: 30: "graphic05-free-img-1024x42.png"; s: 5: "width"; i: 1024; s: 6: "height"; i: 42; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 87: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 38: "2019/06/graphic05-free-img-1024x42.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 9: "thumbnail"; a: 5: { s: 4: "file"; s: 29: "graphic05-free-img-150x79.png"; s: 5: "width"; i: 150; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-150x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 12: "medium_large"; a: 5: { s: 4: "file"; s: 29: "graphic05-free-img-768x31.png"; s: 5: "width"; i: 768; s: 6: "height"; i: 31; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-768x31.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 9: "1536x1536"; a: 5: { s: 4: "file"; s: 30: "graphic05-free-img-1536x63.png"; s: 5: "width"; i: 1536; s: 6: "height"; i: 63; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 87: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 38: "2019/06/graphic05-free-img-1536x63.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 21: "woocommerce_thumbnail"; a: 6: { s: 4: "file"; s: 29: "graphic05-free-img-300x79.png"; s: 5: "width"; i: 300; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 9: "uncropped"; b: 0; s: 2: "s3"; a: 9: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-300x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 18: "woocommerce_single"; a: 5: { s: 4: "file"; s: 29: "graphic05-free-img-600x25.png"; s: 5: "width"; i: 600; s: 6: "height"; i: 25; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-600x25.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 29: "woocommerce_gallery_thumbnail"; a: 5: { s: 4: "file"; s: 29: "graphic05-free-img-100x79.png"; s: 5: "width"; i: 100; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-100x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 12: "shop_catalog"; a: 5: { s: 4: "file"; s: 38: "uGs5Baea-graphic05-free-img-300x79.png"; s: 5: "width"; i: 300; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 95: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 46: "2019/06/uGs5Baea-graphic05-free-img-300x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 11: "shop_single"; a: 5: { s: 4: "file"; s: 38: "uGs5Baea-graphic05-free-img-600x25.png"; s: 5: "width"; i: 600; s: 6: "height"; i: 25; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 95: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 46: "2019/06/uGs5Baea-graphic05-free-img-600x25.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 14: "shop_thumbnail"; a: 5: { s: 4: "file"; s: 38: "uGs5Baea-graphic05-free-img-100x79.png"; s: 5: "width"; i: 100; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 9: { s: 3: "url"; s: 95: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 46: "2019/06/uGs5Baea-graphic05-free-img-100x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 11: "woosc-large"; a: 5: { s: 4: "file"; s: 29: "graphic05-free-img-600x79.png"; s: 5: "width"; i: 600; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 10: { s: 3: "url"; s: 86: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 37: "2019/06/graphic05-free-img-600x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 7: "formats"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } s: 11: "woosc-small"; a: 5: { s: 4: "file"; s: 28: "graphic05-free-img-96x79.png"; s: 5: "width"; i: 96; s: 6: "height"; i: 79; s: 9: "mime-type"; s: 9: "image/png"; s: 2: "s3"; a: 10: { s: 3: "url"; s: 85: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 36: "2019/06/graphic05-free-img-96x79.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 7: "formats"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } } } s: 10: "image_meta"; a: 12: { s: 8: "aperture"; s: 1: "0"; s: 6: "credit"; s: 0: ""; s: 6: "camera"; s: 0: ""; s: 7: "caption"; s: 0: ""; s: 17: "created_timestamp"; s: 1: "0"; s: 9: "copyright"; s: 0: ""; s: 12: "focal_length"; s: 1: "0"; s: 3: "iso"; s: 1: "0"; s: 13: "shutter_speed"; s: 1: "0"; s: 5: "title"; s: 0: ""; s: 11: "orientation"; s: 1: "0"; s: 8: "keywords"; a: 0: {} } s: 2: "s3"; a: 10: { s: 3: "url"; s: 88: ""; s: 6: "bucket"; s: 17: "images-volkistore"; s: 7: "privacy"; s: 11: "public-read"; s: 3: "key"; s: 39: "2019/06/drGvNCCD-graphic05-free-img.png"; s: 8: "provider"; s: 6: "google"; s: 1: "v"; s: 5: "4.0.2"; s: 9: "optimized"; b: 0; s: 7: "options"; a: 0: {} s: 7: "formats"; a: 0: {} s: 9: "mime-type"; s: 9: "image/png"; } }
- The topic ‘How to reduce amount of image sizes stored in DB’ is closed to new replies.