[Forum] MySQL Error : The table 'session' is full

[OutSourceThis]

I have a very large forum and its getting tons of traffic, at least 1-2 posts every minute. Every two days around every 40 hours my database crashes with the following issue. MySQL Error : The table 'session' is full .

I go in and delete the rows and restart Mysql but this keeps happening every 2 days. How can I stop the seesion table from filling up or what configuration do I need to setup. I own the server and memory/cpu is not an issue. but there must be something I can do here.
Windows 2008R2 is the OS.


Help!
Thanks in advance

[Trevor Hannant]

Are your cron jobs running OK? Did you edit the footer template at all?

[OutSourceThis]

I did not edit the footer template at all and I don;t have any cron jobs running on the server.

[Andy]

What do you have this set at?

Admin CP -> Settings -> Options -> Cookies and HTTP Header Options -> Session Timeout

[OutSourceThis]

1200

[Andy]

1200

That number is fine.

Check that you have the cron job running which prunes the session table:

Admin CP -> Scheduled Tasks -> Scheduled Task Manager -> Hourly Cleanup -> Checked

[Winter Sonata]

That number is fine.

Check that you have the cron job running which prunes the session table:

Admin CP -> Scheduled Tasks -> Scheduled Task Manager -> Hourly Cleanup -> Checked

what should I do here exactly ? I am having the same issue

[CtrlAltDel]

Make sure it's checked and running. You could even force a run and see if its running properly.

[OutSourceThis]

That number is fine.

Check that you have the cron job running which prunes the session table:

Admin CP -> Scheduled Tasks -> Scheduled Task Manager -> Hourly Cleanup -> Checked

Yes this is checked and running. Seems like Vbulletin can't handle the load. Not sure what I can do other then a cron job to delete the sessions directly from the db. Anybode have any thoughts???

[George L]

Problem could partly be server config related. You might want to head over to Server config forum http://www.vbulletin.com/go/serverconfig and post info asked at http://www.vbulletin.com/go/tweak

[Andy]

Not sure what I can do other then a cron job to delete the sessions directly from the db. Anybode have any thoughts???

You could certainly do that.