Jump to content
Symphony

Huge increase in SQL DB size due to Table: psik_layered_filter_block

Recommended Posts

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 by Symphony
clarification (see edit history)

Share this post


Link to post
Share on other sites

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";}}}

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More