Database getting huge all the time

  • Resolved ceyhunyildiz

    (@ceyhunyildiz)


    3 years, 4 months ago

    Hey,

    I have a bit of an issue. In the last couple of days, the size of my database has started growing. From the original database size of around 2450MB, it’s not grown to 6.5GB. And wp_litespeed_cssjs is taking most of that size. It has over 108,000 rows.

    I don’t remember changing any one particular setting. Although I do play around with the settings on a regular basis.

    After I click Clean All and Clean CSS/JS Optimiser, it goes away and stays small for a while, but after that again it starts to grow exponentially.

    I have already done the steps described here https://docs.litespeedtech.com/lscache/lscwp/ts-optimize/#disk-space-filling-fast and excluded -text/javascript string in JS excludes but it did not help.

    Can you please help me understand why this happens and how can I prevent it?

    Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support qtwrk

    (@qtwrk)

    Hi,

    it’s most likely you did not exclude all the random string , or not only JS, but also CSS

    it’s due to JS/CSS inline combine , some plugin/theme generates a random string like block-123 and then block-456 …etc

    these will force the LSCWP to think they are different files/contents and make it generate a new sets of combined files , with many pages accumulate , it grows up in size

    you can simply turn off inline combine for the time being , this issue will also be addressed in new version that is currently at beta test stage

    Best regards,

    Thread Starter ceyhunyildiz

    (@ceyhunyildiz)

    Okay I found the difference with Diff Checker,

    <script src=’https://www.example.com/wp-content/plugins/woo-notification/js/woo-notification.min.js&#8217; id=’woo-notification-js’ type=”0b3cde88841b269d396ebe3b-text/javascript”></script>

    <script src=’https://www.example.com/wp-content/plugins/woo-notification/js/woo-notification.min.js&#8217; id=’woo-notification-js’ type=”85ff85557b30ed2c0b037927-text/javascript”></script>

    I added to Tuning > JS Excludes “-text/javascript” this line but it doesn’t seem to be working

    Plugin Support qtwrk

    (@qtwrk)

    no no , thigns like type=”0b3cde88841b269d396ebe3b-text/javascript”> doesn’t count

    you will be looking for something like this :

    example for CSS 

    <style>
#page-header-248571299 .title-bg {
  background-image: url(https://www.domain.com/wp-content/uploads/2020/11/xxx.jpeg);
}
</style>

    in this case , 248571299 is the radom string that changes on each page

    example for JS

    <script type='text/javascript' id='ht_ctc_app_js-js-extra'>
/* <![CDATA[ */
var ht_ctc_chat_var = {"number":"123123123","pre_filled":"xxxx https:\/\/www.domain.com\/producto\/xxxxxxxxxxx.html :","dis_m":"show","dis_d":"show","css":"display: none; cursor: pointer; z-index: 99999999;","pos_d":"position: fixed; bottom: 10px; right: 10px;","pos_m":"position: fixed; bottom: 10px; right: 10px;","schedule":"no","se":"no-show-effects","ani":"no-animations","web":"y"};
/* ]]> */
</script>

    this is a whatsapp widget to launch the conversation with link to the page it launched , so it generates URL on each post (just like a random string)

    Thread Starter ceyhunyildiz

    (@ceyhunyildiz)

    I cant find anything like it but the issue still persists. So I guess I will wait for the next update. Thanks for your help

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database getting huge all the time’ is closed to new replies.