Excessive DB size due to yith transients

  • Resolved aghanawi

    (@aghanawi)


    1 year, 11 months ago

    I’m submitting this here as requested on https://www.ads-software.com/support/topic/excessive-db-size-due-to-yith-transients/

    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

    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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support crodriguez1991

    (@crodriguez1991)

    Hi there,

    thanks for contacting us! ??</img>

    Please, try to apply this custom code in the functions.php of your active theme:

    add_filter( 'yith_wcan_suppress_cache', '__return_true' );

    It should prevent to create transients on your site.

    Please, try it and let me know.

    Have a good day.

    Thread Starter aghanawi

    (@aghanawi)

    Thanks Carlos, I have added it. I will monitor and report in 1-2 days.

    Thread Starter aghanawi

    (@aghanawi)

    Thanks Carlos, this has fixed the isssue.

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