Current time: 04-21-2014, 02:02 AM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sessions table
11-24-2006, 10:01 AM (This post was last modified: 11-24-2006 11:02 AM by Falcon4ever.)
Post: #1
Sessions table
Hi,

I've been running mybb on my sites for quite sometime and on one of my bigger sites I'm getting a lot of anonymous users/guests. (It's used as a sort of CMS)

Normally this isn't a problem but this huge amount gives me a very large session table. Because most of the people are visiting the site only once in a few weeks, this session data isn't really useful.

Because of the large amount of session entries the forum itself is becoming slow. For now I have implanted a function which removed/flushes the session entries each xx hour. This solves the speed problem on the forums but...

I wonder if mybb itself has an option to set a session lifetime? I couldn't find any option in the admincp.

*edit* about my table sizes:
Rows 782,967 (sessions table)
Effective 174.404 KB ( ~170 mb)
Visit this user's website Find all posts by this user
Quote this message in a reply
11-24-2006, 04:15 PM
Post: #2
RE: Sessions table
I agree. My forum went down once because my sessions table was too huge. It should trim itself every so often so it doesn't go bad.
Visit this user's website Find all posts by this user
Quote this message in a reply
11-24-2006, 05:59 PM
Post: #3
RE: Sessions table
So perhaps it's an idea to implent something for future releases Wink?
Visit this user's website Find all posts by this user
Quote this message in a reply
11-24-2006, 06:57 PM
Post: #4
RE: Sessions table
So do you want this moved to Suggestions then? Smile

btw, I agree, this would be a nice feature.

[MyBB Templates] [ProgrammingTalk] [Need Smilies? Get Me Smileys!] [My Blog]
ForumUniversity's GlobalWarming Awareness2007 project.
Visit this user's website Find all posts by this user
Quote this message in a reply
11-24-2006, 07:02 PM
Post: #5
RE: Sessions table
Yeh, moved.
Visit this user's website Find all posts by this user
Quote this message in a reply
11-24-2006, 11:12 PM
Post: #6
RE: Sessions table
I did think we actually had this.

It appears we didn't.

Oh well, in 1.2.2 MyBB will automatically clear guest sessions older than 24 hours.
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication