Huge increase in SQL DB size due to Table: psik_layered_filter_block

[Symphony]

We are having quite a few issues since our upgrade from PS 1.7.4.3 to 1.7.6.8 - some of which are covered in other threads and developers are looking into it. As part of those issues, we currently have both the PS (Smarty) cache and our server Litespeed cache disabled.

However, I have noticed that our database size keeps going very large - up to 20x larger. On investigation, this is all down to the table psik_layered_filter_block; our DB size is normally in the region of 50MB, and yet currently sits at over 900MB!

850MB is sat in 80,000 entries in the table psik_layered_filter_block.

Could anyone please explain why that may be? I assume it is related to the Faceted Search module (I have no layered navigation module that I can find)?

The problem is that sometimes we hit the server CPU load limits because of queries to the DB

Are these entries temporary? Can they be deleted? Will they be regenerated if we do delete, and can we prevent this behaviour?

Edited November 13, 2020 by Symphony
clarification (see edit history)

[Symphony]

All the entries seem to have the same format. This is one example of the 89,000 entries:-

 

Hash: 0000d01f5e3600984d911e2a7e59021a

Data: a:1:{s:7:"filters";a:8:{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:91:{i:1;a:2:{s:4:"name";s:6:"Fender";s:3:"nbr";s:2:"68";}i:3;a:2:{s:4:"name";s:6:"Alesis";s:3:"nbr";s:1:"1";}i:5;a:2:{s:4:"name";s:16:"Barnes & Mullins";s:3:"nbr";s:1:"2";}i:6;a:2:{s:4:"name";s:11:"Baton Rouge";s:3:"nbr";s:1:"1";}i:7;a:2:{s:4:"name";s:9:"Breedlove";s:3:"nbr";s:1:"2";}i:9;a:2:{s:4:"name";s:4:"Cort";s:3:"nbr";s:1:"7";}i:12;a:2:{s:4:"name";s:8:"Epiphone";s:3:"nbr";s:2:"92";}i:14;a:2:{s:4:"name";s:7:"Gretsch";s:3:"nbr";s:2:"15";}i:15;a:2:{s:4:"name";s:5:"Guild";s:3:"nbr";s:1:"8";}i:17;a:2:{s:4:"name";s:6:"Ibanez";s:3:"nbr";s:1:"4";}i:21;a:2:{s:4:"name";s:4:"Kala";s:3:"nbr";s:2:"45";}i:24;a:2:{s:4:"name";s:4:"Lani";s:3:"nbr";s:1:"3";}i:26;a:2:{s:4:"name";s:10:"LTD by ESP";s:3:"nbr";s:1:"4";}i:27;a:2:{s:4:"name";s:6:"Mahalo";s:3:"nbr";s:1:"5";}i:28;a:2:{s:4:"name";s:6:"Makala";s:3:"nbr";s:1:"4";}i:29;a:2:{s:4:"name";s:6:"Martin";s:3:"nbr";s:1:"8";}i:32;a:2:{s:4:"name";s:5:"Ozark";s:3:"nbr";s:1:"9";}i:36;a:2:{s:4:"name";s:12:"Rickenbacker";s:3:"nbr";s:1:"3";}i:37;a:2:{s:4:"name";s:6:"Roland";s:3:"nbr";s:1:"3";}i:40;a:2:{s:4:"name";s:5:"Snail";s:3:"nbr";s:1:"1";}i:41;a:2:{s:4:"name";s:6:"Squier";s:3:"nbr";s:2:"29";}i:42;a:2:{s:4:"name";s:5:"Stagg";s:3:"nbr";s:2:"34";}i:44;a:2:{s:4:"name";s:20:"Sterling by Musicman";s:3:"nbr";s:1:"1";}i:46;a:2:{s:4:"name";s:8:"Takamine";s:3:"nbr";s:1:"2";}i:47;a:2:{s:4:"name";s:10:"Tanglewood";s:3:"nbr";s:2:"27";}i:48;a:2:{s:4:"name";s:6:"Taylor";s:3:"nbr";s:2:"32";}i:50;a:2:{s:4:"name";s:7:"Vintage";s:3:"nbr";s:1:"9";}i:51;a:2:{s:4:"name";s:6:"Yamaha";s:3:"nbr";s:2:"40";}i:54;a:2:{s:4:"name";s:6:"Kramer";s:3:"nbr";s:1:"3";}i:55;a:2:{s:4:"name";s:4:"Boss";s:3:"nbr";s:2:"46";}i:57;a:2:{s:4:"name";s:8:"Marshall";s:3:"nbr";s:2:"13";}i:58;a:2:{s:4:"name";s:6:"Dunlop";s:3:"nbr";s:1:"3";}i:59;a:2:{s:4:"name";s:4:"Korg";s:3:"nbr";s:1:"1";}i:61;a:2:{s:4:"name";s:16:"Electro Harmonix";s:3:"nbr";s:2:"42";}i:62;a:2:{s:4:"name";s:3:"MXR";s:3:"nbr";s:1:"4";}i:63;a:2:{s:4:"name";s:4:"Zoom";s:3:"nbr";s:2:"11";}i:65;a:2:{s:4:"name";s:5:"Mooer";s:3:"nbr";s:1:"3";}i:66;a:2:{s:4:"name";s:5:"Chord";s:3:"nbr";s:2:"15";}i:76;a:3:{s:4:"name";s:6:"Orange";s:3:"nbr";s:2:"16";s:7:"checked";b:1;}i:77;a:2:{s:4:"name";s:3:"Vox";s:3:"nbr";s:1:"6";}i:78;a:2:{s:4:"name";s:6:"Line 6";s:3:"nbr";s:1:"4";}i:79;a:2:{s:4:"name";s:4:"Eden";s:3:"nbr";s:1:"3";}i:85;a:2:{s:4:"name";s:10:"Ernie Ball";s:3:"nbr";s:1:"1";}i:86;a:2:{s:4:"name";s:7:"Generic";s:3:"nbr";s:1:"3";}i:90;a:3:{s:4:"name";s:12:"Trevor James";s:3:"nbr";s:1:"3";s:7:"checked";b:1;}i:94;a:2:{s:4:"name";s:9:"-various-";s:3:"nbr";s:1:"1";}i:97;a:2:{s:4:"name";s:7:"Eastman";s:3:"nbr";s:1:"5";}i:99;a:2:{s:4:"name";s:9:"Primavera";s:3:"nbr";s:1:"8";}i:100;a:2:{s:4:"name";s:9:"Hidersine";s:3:"nbr";s:1:"7";}i:102;a:2:{s:4:"name";s:7:"Stentor";s:3:"nbr";s:1:"7";}i:105;a:2:{s:4:"name";s:6:"Gibson";s:3:"nbr";s:2:"24";}i:106;a:2:{s:4:"name";s:2:"SX";s:3:"nbr";s:1:"8";}i:107;a:2:{s:4:"name";s:5:"Natal";s:3:"nbr";s:1:"2";}i:124;a:2:{s:4:"name";s:5:"Sigma";s:3:"nbr";s:1:"6";}i:137;a:2:{s:4:"name";s:3:"PRS";s:3:"nbr";s:2:"10";}i:141;a:2:{s:4:"name";s:14:"Seymour Duncan";s:3:"nbr";s:1:"6";}i:142;a:2:{s:4:"name";s:3:"EMG";s:3:"nbr";s:1:"3";}i:144;a:2:{s:4:"name";s:4:"Joyo";s:3:"nbr";s:2:"38";}i:151;a:2:{s:4:"name";s:5:"Faith";s:3:"nbr";s:1:"2";}i:157;a:2:{s:4:"name";s:6:"Peavey";s:3:"nbr";s:1:"1";}i:160;a:2:{s:4:"name";s:7:"Jackson";s:3:"nbr";s:1:"9";}i:166;a:2:{s:4:"name";s:3:"Kun";s:3:"nbr";s:1:"1";}i:175;a:2:{s:4:"name";s:15:"Simon & Patrick";s:3:"nbr";s:1:"2";}i:178;a:2:{s:4:"name";s:6:"Sabian";s:3:"nbr";s:1:"2";}i:181;a:2:{s:4:"name";s:10:"JHS Hornby";s:3:"nbr";s:1:"1";}i:184;a:2:{s:4:"name";s:7:"Ko'olau";s:3:"nbr";s:1:"6";}i:189;a:2:{s:4:"name";s:9:"Blackstar";s:3:"nbr";s:2:"32";}i:196;a:2:{s:4:"name";s:10:"Adam Black";s:3:"nbr";s:2:"11";}i:199;a:2:{s:4:"name";s:6:"Italia";s:3:"nbr";s:1:"1";}i:200;a:2:{s:4:"name";s:5:"Ampeg";s:3:"nbr";s:1:"8";}i:208;a:2:{s:4:"name";s:5:"Dr. J";s:3:"nbr";s:1:"1";}i:213;a:3:{s:4:"name";s:3:"MTD";s:3:"nbr";s:1:"1";s:7:"checked";b:1;}i:215;a:2:{s:4:"name";s:7:"Cordoba";s:3:"nbr";s:1:"8";}i:219;a:2:{s:4:"name";s:8:"Carlsbro";s:3:"nbr";s:1:"6";}i:220;a:2:{s:4:"name";s:4:"GATT";s:3:"nbr";s:1:"2";}i:229;a:2:{s:4:"name";s:7:"Warwick";s:3:"nbr";s:1:"2";}i:242;a:2:{s:4:"name";s:8:"Goldtone";s:3:"nbr";s:1:"1";}i:243;a:2:{s:4:"name";s:5:"Blaxx";s:3:"nbr";s:1:"1";}i:244;a:2:{s:4:"name";s:5:"Godin";s:3:"nbr";s:1:"6";}i:246;a:2:{s:4:"name";s:11:"Carl Martin";s:3:"nbr";s:1:"7";}i:248;a:2:{s:4:"name";s:10:"Duesenberg";s:3:"nbr";s:1:"1";}i:250;a:2:{s:4:"name";s:14:"Art & Lutherie";s:3:"nbr";s:1:"3";}i:251;a:2:{s:4:"name";s:9:"Tonerider";s:3:"nbr";s:2:"10";}i:252;a:2:{s:4:"name";s:7:"Seagull";s:3:"nbr";s:1:"4";}i:256;a:2:{s:4:"name";s:6:"Logjam";s:3:"nbr";s:1:"3";}i:257;a:2:{s:4:"name";s:3:"Keo";s:3:"nbr";s:1:"1";}i:258;a:2:{s:4:"name";s:8:"Kanile'a";s:3:"nbr";s:1:"1";}i:259;a:2:{s:4:"name";s:7:"Fishman";s:3:"nbr";s:1:"2";}i:260;a:2:{s:4:"name";s:7:"Crafter";s:3:"nbr";s:1:"1";}i:262;a:2:{s:4:"name";s:3:"Kai";s:3:"nbr";s:1:"1";}i:269;a:2:{s:4:"name";s:13:"Positive Grid";s:3:"nbr";s:1:"2";}}s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:1;a:12:{s:9:"type_lite";s:5:"price";s:4:"type";s:5:"price";s:6:"id_key";i:0;s:4:"name";s:5:"Price";s:3:"max";d:769;s:3:"min";d:24;s:4:"unit";s:2:"£";s:14:"specifications";a:10:{s:6:"symbol";a:11:{i:0;s:1:".";i:1;s:1:",";i:2;s:1:";";i:3;s:1:"%";i:4;s:1:"-";i:5;s:1:"+";i:6;s:1:"E";i:7;s:2:"×";i:8;s:3:"‰";i:9;s:3:"∞";i:10;s:3:"NaN";}s:12:"currencyCode";s:3:"GBP";s:14:"currencySymbol";s:2:"£";s:15:"positivePattern";s:10:"¤#,##0.00";s:15:"negativePattern";s:11:"-¤#,##0.00";s:17:"maxFractionDigits";i:2;s:17:"minFractionDigits";i:2;s:12:"groupingUsed";b:1;s:16:"primaryGroupSize";i:3;s:18:"secondaryGroupSize";i:3;}s:17:"filter_show_limit";i:0;s:11:"filter_type";i:3;s:3:"nbr";i:20;s:5:"value";N;}i:2;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:1:"1";s:6:"values";a:1:{i:20;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:15:"Great Condition";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:9:"Condition";s:8:"url_name";s:0:"";s:10:"meta_title";s:0:"";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:1:"4";s:6:"values";a:1:{i:18;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:1:"5";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:11:"No. Strings";s:8:"url_name";s:0:"";s:10:"meta_title";s:0:"";s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:4;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:1:"5";s:6:"values";a:1:{i:5;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:12:"Right-handed";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:12:"Left / Right";s:8:"url_name";s:0:"";s:10:"meta_title";s:0:"";s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:5;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:1:"8";s:6:"values";a:1:{i:19;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:5:"Other";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:10:"Bass Shape";s:8:"url_name";s:0:"";s:10:"meta_title";s:0:"";s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:6;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:2:"13";s:6:"values";a:2:{i:42;a:4:{s:3:"nbr";s:1:"8";s:4:"name";s:24:"Solid State: Traditional";s:8:"url_name";N;s:10:"meta_title";N;}i:43;a:4:{s:3:"nbr";s:1:"1";s:4:"name";s:22:"Traditional Full Valve";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:20:"Amplifier Technology";s:8:"url_name";s:0:"";s:10:"meta_title";s:0:"";s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}i:7;a:9:{s:9:"type_lite";s:10:"id_feature";s:4:"type";s:10:"id_feature";s:6:"id_key";s:2:"14";s:6:"values";a:3:{i:45;a:4:{s:3:"nbr";s:1:"7";s:4:"name";s:21:"Amplifier Head (Head)";s:8:"url_name";N;s:10:"meta_title";N;}i:41;a:4:{s:3:"nbr";s:1:"2";s:4:"name";s:15:"Combo Amplifier";s:8:"url_name";N;s:10:"meta_title";N;}i:44;a:4:{s:3:"nbr";s:1:"3";s:4:"name";s:21:"Speaker Cabinet (Cab)";s:8:"url_name";N;s:10:"meta_title";N;}}s:4:"name";s:14:"Amplifier Type";s:8:"url_name";s:0:"";s:10:"meta_title";s:0:"";s:17:"filter_show_limit";i:0;s:11:"filter_type";s:1:"0";}}}

 

[walihn]

thank you symphony ❤️

 

 

 

 

 

snaptube vidmate word to pdf

Edited November 18, 2020 by walihn (see edit history)