|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi guys, recently my vb_sessions table has been getting full resulting in visitors receiving the following MySQL errors when visiting my board. Quote: MySQL Error : The table 'VB_session' is full 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 __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Attachment DB Table corrupt after update to 4.2.0 (from 4.0.x) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 09-15-2012 10:10 PM |
vb error adminutil table is 1.9gb in size | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-29-2010 08:30 AM |
Forum Vbulletin "Searchlog" table size exceeds 4gb? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 02-08-2010 03:00 AM |
Question regarding "session" table, locks and table size... | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-22-2009 12:10 PM |
Table size location | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-22-2009 10:00 AM |