Frequent Increase of cache table dramatically

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pjclas
    New Member
    • Aug 2012
    • 25
    • 4.2.X

    #16
    Originally posted by Zachery
    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?

    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #17
      An entire pages output, for every single page on your site (vBulletin pages, anyway), in every language.

      Comment

      • pjclas
        New Member
        • Aug 2012
        • 25
        • 4.2.X

        #18
        Originally posted by Zachery
        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.

        Comment


        • Zachery
          Zachery commented
          Editing a comment
          Just for guests.
      • sandrose
        Senior Member
        • Feb 2001
        • 389
        • 5.0.X

        #19
        Thank you Zachery for your support.
        http://www.vbulletin.com/forum/filed...ledataid=63608

        Comment

        • fsmex
          New Member
          • Mar 2009
          • 25
          • 5.0.X

          #20
          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?

          Comment

          • Zachery
            Former vBulletin Support
            • Jul 2002
            • 59097

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

            Comment

            • fsmex
              New Member
              • Mar 2009
              • 25
              • 5.0.X

              #22
              Without the Cache table the DB size is 2.8 GB

              Comment

              • pjclas
                New Member
                • Aug 2012
                • 25
                • 4.2.X

                #23
                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.

                Comment

                • fsmex
                  New Member
                  • Mar 2009
                  • 25
                  • 5.0.X

                  #24
                  Originally posted by pjclas
                  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

                  Comment

                  • Zachery
                    Former vBulletin Support
                    • Jul 2002
                    • 59097

                    #25
                    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?

                    Comment

                    • pjclas
                      New Member
                      • Aug 2012
                      • 25
                      • 4.2.X

                      #26
                      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, 2:51am.

                      Comment

                      • fsmex
                        New Member
                        • Mar 2009
                        • 25
                        • 5.0.X

                        #27
                        I´m Running 5.1.2 and just opened a ticket requesting to be forwarded to Zachery.

                        Comment

                        • pjclas
                          New Member
                          • Aug 2012
                          • 25
                          • 4.2.X

                          #28
                          Originally posted by fsmex
                          I´m Running 5.1.2 and just opened a ticket requesting to be forwarded to Zachery.
                          Nice, please let me know what you find out because they won't help me on 5.1.1.

                          Comment

                          • fsmex
                            New Member
                            • Mar 2009
                            • 25
                            • 5.0.X

                            #29
                            Well the response was pretty much to wait for 5.1.3 and see if the problem is solved, since a lot of cache issues are solved on 5.1.3

                            5.1.3 seems to have a number of fixes around cache issues. Once it is out of beta I'd suggest you upgrade to it, and see how it goes after clearing the system cache post upgrade.
                            Let's wait...

                            Comment

                            • pjclas
                              New Member
                              • Aug 2012
                              • 25
                              • 4.2.X

                              #30
                              Originally posted by fsmex
                              Well the response was pretty much to wait for 5.1.3 and see if the problem is solved, since a lot of cache issues are solved on 5.1.3

                              Let's wait...
                              I guess my confusion is why nobody else seems to have this problem if it's just some improved cache handling in 5.1.3... Are other people just not paying attention or are their forums so small it's not noticeable?

                              Comment

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