The cache_advagg_aggregates cache bin can get quite large at times. Going to see what I can do; thinking of decreasing the time between trims.

CommentFileSizeAuthor
#10 advagg-2730443-9-smaller-cache-items.patch3.51 KBmikeytown2
#5 advagg-2730443-5-inline-js-min-cache.patch940 bytesmikeytown2
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mikeytown2 created an issue. See original summary.

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented

Just checked and the oldest entry is 4 days ago... so this isn't a simple fix. Looking and there are some 12MB cache entries so I should be able to clean this up more.

dasrecht’s picture

dasrecht CreditAttribution: dasrecht commented

Hi there, i just got into the same situation. Our cache_adgavv_aggregates table exceeded the size of 14.9 GB. Is there a value which can be tweaked to limit the size of the aggregate table?

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented

Looking into this and it appears to be caused by large inline blocks of css and/or js code. Also looks like the advagg:js_compress key does not get cleaned up. Will need to fix that.

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Active » Needs review
FileSize
advagg-2730443-5-inline-js-min-cache.patch940 bytes

First step is to only cache inline js for 1 hour instead of 7 days.

  • mikeytown2 committed 83cb77d on 7.x-2.x 
    Issue #2730443 by mikeytown2: cache_advagg_aggregates large
mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented

This should fix most of the issues. Will look into the full render cache, if inline should not be cached.

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Needs review » Active

  • mikeytown2 committed 7c240b6 on 7.x-2.x 
    Issue #2730443 by mikeytown2: cache_advagg_aggregates large
mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Active » Fixed
FileSize
advagg-2730443-9-smaller-cache-items.patch3.51 KB

This has been committed. Cache should shrink after a week or two.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

slinky’s picture

slinky CreditAttribution: slinky commented

I much appreciate this module but I do have a concern. Our database was 600MB. After installing the module, this table alone added 505MB in over 54,000 table entries. I haven't looked into this too deeply but the heft is tremendous and I'm finding it challenging to believe that caching is being performed efficiently.

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented

@slinky
The more organized your css and js is loaded on your page the smaller it will be. Order of css and js files matters. AdvAgg doesn't change the order so it has to record every permutation. So in your case you have 54k different file combinations of css and js.