Announcement

Collapse
No announcement yet.

Frequent Increase of cache table dramatically

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • pjclas
    replied
    I already opened up a support ticket for this problem, Ticketid: <edited>. I asked them to forward it to you. The current state is they wanted me to upgrade to 5.1.2 before they looked into it, but I am not ready to do that yet. And from the sounds of it, fsmex says this problem still exists in 5.1.2 anyway. I am waiting for 5.1.3 to get out of beta since some tickets I wrote are fixed in 5.1.3. I've had to modify some vb code to fix some bugs so upgrading is not completely simple for me. I'd rather avoid it unless I know it fixes something.
    Last edited by Mark.B; Fri 5 Sep '14, 3:51am.

    Leave a comment:


  • Zachery
    replied
    Can anyone having a very large cache table open a support ticket with my attention so I can take a look at what is going on?

    Leave a comment:


  • fsmex
    replied
    Originally posted by pjclas View Post
    Something is wrong with this picture, lol. I have to clear my system cache every day.
    I'm doing the same! clearing it every day :S

    Leave a comment:


  • pjclas
    replied
    Didn't make any difference for me either. After about 7 hours my database cache table is 19G! And no other vb table in the database is greater than 17M. I do have other non vb tables that are bigger, but I can't see why vb would be caching anything in those since they are not vb tables.

    Code:
    -rw-rw---- 1 mysql mysql        8754 Jan 11  2014 vb_cache.frm
    -rw-rw---- 1 mysql mysql 19428021036 Sep  3 18:56 vb_cache.MYD
    -rw-rw---- 1 mysql mysql      615424 Sep  3 18:56 vb_cache.MYI
    Something is wrong with this picture, lol. I have to clear my system cache every day.

    Leave a comment:


  • fsmex
    replied
    Without the Cache table the DB size is 2.8 GB

    Leave a comment:


  • Zachery
    replied
    Its not intended to completely stop it. How big is the rest of your database, in comparison to your cache table?

    Leave a comment:


  • Zachery
    commented on 's reply
    Just for guests.

  • fsmex
    replied
    OK my cache table grew from 0 this morning to 1.1 GB at this time, I still think this is too much.

    Is this normal or is there something I can still do about it?

    Leave a comment:


  • sandrose
    replied
    Thank you Zachery for your support.

    Leave a comment:


  • pjclas
    replied
    Originally posted by Zachery View Post
    An entire pages output, for every single page on your site (vBulletin pages, anyway), in every language.
    Ah wow. I assumed it was just the db data that was ever cached. So all cookie and session preferences for each user is cached in the form of the the actual html output for every guest? Screw that, lol, there is no reason to cache that data on my forums... people can register.

    Leave a comment:


  • Zachery
    replied
    An entire pages output, for every single page on your site (vBulletin pages, anyway), in every language.

    Leave a comment:


  • pjclas
    replied
    Originally posted by Zachery View Post
    That setting, set it to 0, and clear the system cache.
    I also just made this change. So what exactly is guest cache? What would be cached for guests that would take up so much space?

    Leave a comment:


  • fsmex
    replied
    Ok Thank you Done that, will wait for results.

    Leave a comment:


  • Zachery
    replied
    That setting, set it to 0, and clear the system cache.

    Leave a comment:


  • fsmex
    replied
    Originally posted by Zachery View Post
    You've disabled the guest cache?
    No I haven't

    Is this done here?

    -Minutes to Cache Content for Guests-?

    Or somewhere else?

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X