Cpsession and Session Tables very Big!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xgiovio
    New Member
    • May 2011
    • 14
    • 5.0.X

    Cpsession and Session Tables very Big!

    Hello, on my vbulletin database, the two tables ( cpsession and session) are too big. About 200 mb. I tried the delete from, truncate from queries. After the query the size is 0 byte but at the first visit on the forum, the size increases again. One visit make them jump to 200 mb.
    I tried to change them to Myislam instead of memory and the problem has gone. Why i can't use them on memory?
    Please help me.
    Thank you
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    The MySQL info on this is:

    The maximum size of MEMORY tables is limited by the max_heap_table_size system variable, which has a default value of 16MB. To have larger (or smaller) MEMORY tables, you must change the value of this variable.




    Looks like you want to reduce that value for a smaller table size.

    Comment

    • xgiovio
      New Member
      • May 2011
      • 14
      • 5.0.X

      #3
      unfortunately i'm on a shared hosting. i think i can't access to that value.

      Comment

      • Hartmut
        Senior Member
        • Nov 2007
        • 2870
        • 4.2.x

        #4
        You should ask your web host to be sure about this, sometimes that can be changed.
        No private support, only PM me when I ask for it. Support in the forums only.

        Comment

        • xgiovio
          New Member
          • May 2011
          • 14
          • 5.0.X

          #5
          i have opened a ticket. I will wait for an answer. Thank you

          Comment

          • Sir_Rai
            New Member
            • Sep 2012
            • 1
            • 4.2.X

            #6
            I'm having the same problem with Aruba hosting. These memory tables are so huge and when I truncated it if someone enters in the web, the "session" table increase again about 100mb. If someone enters in admincp the 'CPsession' table increase too...

            Did you guys have resolved this problem?

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73981

              #7
              Originally posted by Sir_Rai
              I'm having the same problem with Aruba hosting. These memory tables are so huge and when I truncated it if someone enters in the web, the "session" table increase again about 100mb. If someone enters in admincp the 'CPsession' table increase too...

              Did you guys have resolved this problem?
              It isn't a problem. It is how these types of tables work. They will not grow larger than that and old data is purged from memory on a regular basis. If you want smaller tables, which in turn limits how many people can visit your site, then you need to contact your hosting provider and ask them to lower the size allocated to them.

              100MB is a very small allocation in today's computing environment.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • xgiovio
                New Member
                • May 2011
                • 14
                • 5.0.X

                #8
                it's isnt a database limit because the problem persists also on a single visit.
                The solution for Aruba is go to the table proprerty and set it "NOT MEMORY" but equale to others.
                I've also contacted aruba showing them my problem and they ansered me that the huge memory allocation isn't real so it's normal.

                Comment

                • xgiovio
                  New Member
                  • May 2011
                  • 14
                  • 5.0.X

                  #9
                  Change Cpsession and session tables to myislam

                  Comment

                  • Wayne Luke
                    vBulletin Technical Support Lead
                    • Aug 2000
                    • 73981

                    #10
                    Originally posted by xgiovio
                    Change Cpsession and session tables to myislam
                    This would destroy performance but it a crude workaround.
                    Translations provided by Google.

                    Wayne Luke
                    The Rabid Badger - a vBulletin Cloud demonstration site.
                    vBulletin 5 API

                    Comment

                    Related Topics

                    Collapse

                    Working...