• 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.