Mitch100degrees
Wed 9th Jul '08, 9:09pm
Hello,
I recently moved to a new server from MySQL 4.1 to MySQL 5 and I keep getting database errors from my forum.
Invalid SQL:
UPDATE vb_session
SET lastactivity = 1215643669, location = '/forum/index.php',
inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '7d9097fd7b1d3fb16b94c2f79ba25e6f';
MySQL Error : MySQL server has gone away
Error Number : 2006Now its only doing this on session update queries, and I should note the server is running very fast. The forum is fairly active and I only get about 50-75 of these a day or so.
It operates on a shared hosting server, so I have to keep the MySQL config in check. I have thread_cache_size set to 256 and wait_timeout set to 180. I notice that the connections from my vBulletin forum drop as soon as they are done, however connections from other scripts my clients are using tend to hang around till wait_timeout kills them. I have max_connections set to 500 so I worry that if I set wait_timeout higher, that value will be reached. Also the usepconnect variable in the config file is set to 0.
Can someone recommend what I should do?
I recently moved to a new server from MySQL 4.1 to MySQL 5 and I keep getting database errors from my forum.
Invalid SQL:
UPDATE vb_session
SET lastactivity = 1215643669, location = '/forum/index.php',
inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '7d9097fd7b1d3fb16b94c2f79ba25e6f';
MySQL Error : MySQL server has gone away
Error Number : 2006Now its only doing this on session update queries, and I should note the server is running very fast. The forum is fairly active and I only get about 50-75 of these a day or so.
It operates on a shared hosting server, so I have to keep the MySQL config in check. I have thread_cache_size set to 256 and wait_timeout set to 180. I notice that the connections from my vBulletin forum drop as soon as they are done, however connections from other scripts my clients are using tend to hang around till wait_timeout kills them. I have max_connections set to 500 so I worry that if I set wait_timeout higher, that value will be reached. Also the usepconnect variable in the config file is set to 0.
Can someone recommend what I should do?