Announcement

Collapse
No announcement yet.

Cpsession and Session Tables very Big!

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

  • 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

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


    http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

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

    Comment


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

      Comment


      • #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


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

          Comment


          • #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


            • #7
              Originally posted by Sir_Rai View Post
              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


              • #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


                • #9
                  Change Cpsession and session tables to myislam

                  Comment


                  • #10
                    Originally posted by xgiovio View Post
                    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...
                    X