Excessive DB size due to yith transients

  • Resolved aghanawi

    (@aghanawi)


    2 years ago

    I’m using the following plugins

    YITH Infinite Scrolling
    YITH WooCommerce Ajax Product Filter

    I noticed our DB was getting very slow, upon checking I found the size to be almost 10GB. After investigating I see that YITH is producing significant transient data in wp_options table… I cleaned this once by removing all yith entries and it went down to 39MB, but a couple of days later it is back again…

    here is some data on current DB

    SELECT COUNT(*) FROM wp_options WHERE option_name LIKE “%yith%”;

    count 178,657

    SELECT ‘totalsize’ as name, ROUND(SUM(LENGTH(option_value))) as value FROM wp_options where option_name like ‘%yith%’;

    name value
    totalsize 3437217447

    Can you please advice if this is a known issue?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Giuseppe Madaudo

    (@askmagic)

    Hi there,
    this is the first time that someone report this issue as I know, we’ll investigate and if necessary send an update in order to fix that.
    Thank you for reporting.

    Thread Starter aghanawi

    (@aghanawi)

    Hi ,

    Any luck with this, it continues to happen and we keep running out of space.

    Thread Starter aghanawi

    (@aghanawi)

    In 5 days YITH Transients have built up to make wp_options table 24GB in size, so something is broken.

    I removed them once again, and found that in 3 minutes it generated around 500 entries which have a 1 month expiry. Examples below:

    Name Expiration

    yith_wcan_object_in_terms_1672108182. 2023-01-26 13:29:46
    4 weeks 1 day

    yith_wcan_queried_products_1672108182. 2023-01-26 13:29:46
    4 weeks 1 day

    yith_wcan_object_in_terms_1672108181 2023-01-26 13:29:44
    4 weeks 1 day

    yith_wcan_queried_products_1672108181 2023-01-26 13:29:44
    4 weeks 1 day

    Plugin Support crodriguez1991

    (@crodriguez1991)

    Hello there,

    I hope you’re doing well :D.

    I checked and seems the transients are related to Ajax product filter.

    Please, open a new topic on YITH WooCommerce Ajax Product Filter plugin and share the YITH Transients on that topic.
    In this way we can help you in the dedicated support section for YITH WooCommerce Ajax Product Filter plugin.

    I hope it helps you.

    Have a good day.

    Thread Starter aghanawi

    (@aghanawi)

    Logged https://www.ads-software.com/support/topic/excessive-db-size-due-to-yith-transients-2/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Excessive DB size due to yith transients’ is closed to new replies.