i need a help ..The table 'session' is full ??? and more issues

[Y-ZOOM]

Hello

After i transferred my forum to a dedicated server i faced some problems

This one

:::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::

Database error in vBulletin 3.7.4:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, invideocategory, invideo)
VALUES
('7248dff1742302f045aebca37e0e9366', 2, '82.114.184.107', '17a17e9d86870c3fb9dfb25f570ccfed', 1232994870, '/vb/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1', 0, 0, 0, 0);
MySQL Error : The table 'session' is full
Error Number : 1114
Request Date : Monday, January 26th 2009 @ 04:34:30 PM
Error Date : Monday, January 26th 2009 @ 04:34:30 PM
Script : http://y-zoom.com/vb/
Referrer :
IP Address : 82.114.184.107
Username : Y-zoom
Classname : vB_Database
MySQL Version : 5.0.67-community

:::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::


in my old hosting everything was okay .. is there any settings my server needs

and how can i optimize my server to solve this issue .. ??

i emptied the table but i need another solution to fix that !!


:::::::::

Also i need to make my forum faster .. is there any way to optimize my PHP and Sql to be faster ??

sorry im not good in English

thanks

[Dismounted]

1) Does it error happen often? If it has happened just once, leave it. (Although you may want to check how much free RAM you have on the server, as the session table is stored in memory.)

2) On the vBulletin.com Server Configuration (http://www.vbulletin.com/forum/forumdisplay.php?f=14) forum you can get general PHP/MySQL optimisation suggestions by one of our Support Professionals.