Edit History

OK, so ive blocked that ip address and the connections have dropped a lot, but there are still a few hundred of another IP.

anyhow, ive found the db table that is growing.

ps_layered_filter_block is currently 2.4Gb so Ive just gone into the faceted search module and cleared the cache

(The DB size dropped down to 38Mb)

The data in the "data" column was like this

a:1:{s:7:"filters";a:4:{i:0;a:7:{s:9:"type_lite";s:12:"manufacturer";s:4:"type";s:12:"manufacturer";s:6:"id_key";i:0;s:4:"name";s:5:"Brand";s:6:"values";a:6:{i:5;a:2:{s:4:"name";s:5:"I.V.G";s:3:"nbr";s:1:"1";}i:22;a:2:{s:4:"name";s:10:"Just Juice";s:3:"nbr";s:1:"3";}i:23;a:2:{s:4:"name";s:12:"Vampire Vape";s:3:"nbr";s:1:"4";}i:29;a:2:{s:4:"name";s:11:"Dinner Lady";s:3:"nbr";s:1:"3";}i:34;a:2:{s:4:"name";s:10:"Refill Bar";s:3:"nbr";s:1:"2";}i:35;a:2:{s:4:"name";s:14:"Britannia Gold";s:3:"nbr";s:1:"5";}}s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:1;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:1:"3";s:6:"values";a:1:{i:11;a:4:{s:3:"nbr";s:2:"18";s:4:"name";s:4:"10ml";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:8:"Capacity";s:8:"url_name";N;s:10:"meta_title";N;s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:2;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:2:"21";s:6:"values";a:49:{i:2844;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:7:"Aniseed";s:8:"url_name";N;s:10:"meta_title";N;}i:2848;a:4:{s:3:"nbr";s:1:"5";s:4:"name";s:5:"Apple";s:8:"url_name";N;s:10:"meta_title";N;}i:2847;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:6:"Banana";s:8:"url_name";N;s:10:"meta_title";N;}i:2877;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:7:"Biscuit";s:8:"url_name";N;s:10:"meta_title";N;}i:2843;a:4:{s:3:"nbr";s:1:"5";s:4:"name";s:12:"Blackcurrant";s:8:"url_name";N;s:10:"meta_title";N;}i:2805;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:9:"Blueberry";s:8:"url_name";N;s:10:"meta_title";N;}i:2853;a:4:{s:3:"nbr";s:1:"5";s:4:"name";s:9:"Bubblegum";s:8:"url_name";N;s:10:"meta_title";N;}i:2873;a:4:{s:3:"nbr";s:1:"4";s:4:"name";s:5:"Candy";s:8:"url_name";N;s:10:"meta_title";N;}i:2812;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:7:"Caramel";s:8:"url_name";N;s:10:"meta_title";N;}i:2876;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:6:"Cereal";s:8:"url_name";N;s:10:"meta_title";N;}i:2872;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:10:"Cheesecake";s:8:"url_name";N;s:10:"meta_title";N;}i:2797;a:4:{s:3:"nbr";s:1:"9";s:4:"name";s:6:"Cherry";s:8:"url_name";N;s:10:"meta_title";N;}i:2866;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:6:"Citrus";s:8:"url_name";N;s:10:"meta_title";N;}i:2864;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:7:"Coconut";s:8:"url_name";N;s:10:"meta_title";N;}i:2857;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:6:"Coffee";s:8:"url_name";N;s:10:"meta_title";N;}i:2798;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:4:"Cola";s:8:"url_name";N;s:10:"meta_title";N;}i:2863;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:9:"Cranberry";s:8:"url_name";N;s:10:"meta_title";N;}i:2871;a:5:{s:3:"nbr";s:1:"3";s:4:"name";s:7:"Custard";s:8:"url_name";N;s:10:"meta_title";N;s:7:"checked";b:1;}i:2855;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:12:"Energy Drink";s:8:"url_name";N;s:10:"meta_title";N;}i:2860;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:5:"Grape";s:8:"url_name";N;s:10:"meta_title";N;}i:2865;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:5:"Guava";s:8:"url_name";N;s:10:"meta_title";N;}i:2799;a:4:{s:3:"nbr";s:2:"16";s:4:"name";s:3:"Ice";s:8:"url_name";N;s:10:"meta_title";N;}i:2852;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:4:"Kiwi";s:8:"url_name";N;s:10:"meta_title";N;}i:2861;a:4:{s:3:"nbr";s:1:"4";s:4:"name";s:5:"Lemon";s:8:"url_name";N;s:10:"meta_title";N;}i:2796;a:4:{s:3:"nbr";s:1:"5";s:4:"name";s:8:"Lemonade";s:8:"url_name";N;s:10:"meta_title";N;}i:2800;a:4:{s:3:"nbr";s:1:"6";s:4:"name";s:4:"Lime";s:8:"url_name";N;s:10:"meta_title";N;}i:2850;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:9:"Liquorice";s:8:"url_name";N;s:10:"meta_title";N;}i:2807;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:5:"Mango";s:8:"url_name";N;s:10:"meta_title";N;}i:2875;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:11:"Marshmallow";s:8:"url_name";N;s:10:"meta_title";N;}i:2859;a:5:{s:3:"nbr";s:1:"6";s:4:"name";s:7:"Menthol";s:8:"url_name";N;s:10:"meta_title";N;s:7:"checked";b:1;}i:2858;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:4:"Milk";s:8:"url_name";N;s:10:"meta_title";N;}i:2803;a:4:{s:3:"nbr";s:1:"6";s:4:"name";s:4:"Mint";s:8:"url_name";N;s:10:"meta_title";N;}i:2795;a:4:{s:3:"nbr";s:1:"8";s:4:"name";s:13:"Mixed Berries";s:8:"url_name";N;s:10:"meta_title";N;}i:3025;a:4:{s:3:"nbr";s:1:"5";s:4:"name";s:12:"Mixed Fruits";s:8:"url_name";N;s:10:"meta_title";N;}i:2814;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:4:"Nuts";s:8:"url_name";N;s:10:"meta_title";N;}i:2845;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:6:"Orange";s:8:"url_name";N;s:10:"meta_title";N;}i:2809;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:6:"Papaya";s:8:"url_name";N;s:10:"meta_title";N;}i:2854;a:4:{s:3:"nbr";s:1:"4";s:4:"name";s:13:"Passion Fruit";s:8:"url_name";N;s:10:"meta_title";N;}i:2801;a:4:{s:3:"nbr";s:1:"4";s:4:"name";s:5:"Peach";s:8:"url_name";N;s:10:"meta_title";N;}i:2849;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:4:"Pear";s:8:"url_name";N;s:10:"meta_title";N;}i:2808;a:4:{s:3:"nbr";s:1:"4";s:4:"name";s:9:"Pineapple";s:8:"url_name";N;s:10:"meta_title";N;}i:2856;a:4:{s:3:"nbr";s:1:"7";s:4:"name";s:9:"Raspberry";s:8:"url_name";N;s:10:"meta_title";N;}i:2802;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:4:"Soda";s:8:"url_name";N;s:10:"meta_title";N;}i:2851;a:4:{s:3:"nbr";s:1:"6";s:4:"name";s:10:"Strawberry";s:8:"url_name";N;s:10:"meta_title";N;}i:2867;a:4:{s:3:"nbr";s:1:"4";s:4:"name";s:4:"Tart";s:8:"url_name";N;s:10:"meta_title";N;}i:2810;a:5:{s:3:"nbr";s:1:"9";s:4:"name";s:7:"Tobacco";s:8:"url_name";N;s:10:"meta_title";N;s:7:"checked";b:1;}i:2813;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:6:"Toffee";s:8:"url_name";N;s:10:"meta_title";N;}i:2811;a:4:{s:3:"nbr";s:1:"5";s:4:"name";s:7:"Vanilla";s:8:"url_name";N;s:10:"meta_title";N;}i:2846;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:10:"Watermelon";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:15:"Flavour Profile";s:8:"url_name";N;s:10:"meta_title";N;s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:3;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:2:"18";s:6:"values";a:2:{i:2508;a:4:{s:3:"nbr";s:2:"12";s:4:"name";s:8:"Freebase";s:8:"url_name";N;s:10:"meta_title";N;}i:2509;a:4:{s:3:"nbr";s:1:"6";s:4:"name";s:4:"Salt";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:13:"Nicotine Type";s:8:"url_name";N;s:10:"meta_title";N;s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}}}

Im presuming thats just the cache, but why is it caching so many times ( there we over 100k entries before I cleared it )