Hi guys, recently my vb_sessions table has been getting full resulting in visitors receiving the following MySQL errors when visiting my board.
On doing a little research within these forums, dodgy footer templates / cron issues appear to be one of the key causes so I set the hourly cleanup tasks (1 and 2)!to register success (or otherwise) via the scheduled cron log to check that the crons were running. Since doing so i have been able to validate that the corn jobs are running without issue.
I've also tried increasing the frequency of the crons to run every 30 mins but the vb_sessions table is still filling up
I run my own dedicated server and the forums get between 30- 40,000 visitors a day. During the peak times there are sometimes up to a couple of thousand visitors on the boards. My boards are also very attachment heavy (threads contains images which are hosted on the server). Not sure if this makes much of a difference though.
One of the suggestions i have read is to increase the size of the table by increasing the value in the max_heap_table_size parameter. The thing is, I have no idea how to do this.
Please can someone suggest if this would be the most appropriate action and also confirm how I go about doing this for the vb_sessions table (is this a command used via phpmyadmin)?
Many thanks for any assistance in advance
regards
Mark
MySQL Error : The table 'VB_session' is full
I've also tried increasing the frequency of the crons to run every 30 mins but the vb_sessions table is still filling up
I run my own dedicated server and the forums get between 30- 40,000 visitors a day. During the peak times there are sometimes up to a couple of thousand visitors on the boards. My boards are also very attachment heavy (threads contains images which are hosted on the server). Not sure if this makes much of a difference though.
One of the suggestions i have read is to increase the size of the table by increasing the value in the max_heap_table_size parameter. The thing is, I have no idea how to do this.
Please can someone suggest if this would be the most appropriate action and also confirm how I go about doing this for the vb_sessions table (is this a command used via phpmyadmin)?
Many thanks for any assistance in advance
regards
Mark
Comment