"ca_persistent_cache" large size

UAMAlbany

Hi all,
We host our Collective Access on a VPS server. Over the weekend, our hosting company informed us that we were exceeding our 3 GB limit for MySQL databases. The largest were "ca_persistent_cache , Size: 0.9748 GB, ca_search_log , Size: 0.6512 GB, and ca_sql_search_word_index , Size: 0.5955 GB". We emptied the search log and ran a "rebuild-search-index" utility.

What does "ca_persistent_cache" do and what would the effects of emptying it be. Or alternately, is there a configuration setting to limit its size?

Thanks!

seth

Nothing bad will happen if you clear it, other than people potentially being logged out. You can clear it using caUtils clear-caches

UAMAlbany

Thanks, Seth!

UAMAlbany

Hi all,
Unfortunately we continue to have massive spikes in the size of the "ca_persistent_cache" table. This started happening after an update from 1.7 to 2.0. Periodically run the "caUtils clear-caches" script to clear it, which isn't workable long term. Is there a setting in a configuration file that can limit the size?

Thanks so much

seth

It should automatically clear itself. It does limit its size. I cannot provide a guess as to why that's failing on your system.

UAMAlbany

seth Thanks for the quick reply! Good to know that it should be automatically clearing itself.