MySQL Crashing Frequently

[LCD_Angel]

For about the past 3 weeks, my server has been plagued with MySQL errors. The server seemingly crashes more than twice a day and it down for about 8 hours / day average. The technical support team at my webhost (forsite.com) has told me that my website is causing the errors.

Tom, of Forsite.com told me "your site IS the reason that mysql keep crashing on your server -your scripts open a session but do not close themselves causing the server to have troubles - we are asking you to move your site to another host so you can verify this as well with them"

Server Info:
PHP Version 4.0.6
URL: http://www.paintball-forum.com/forum/

Here is the most frequent error message:

Database error in vBulletin :Link-ID == false, connect failedmysql error: Too many connectionsmysql error number: 1040

I have also noted a couple other errors...

Database error in vBulletin 2.2.6:Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=5208 ORDER BY dateline DESC LIMIT 1mysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/search.phpReferer: http://www.paintball-forum.com/forum/search.php?s=

and

Database error in vBulletin Control Panel 2.2.6:Invalid SQL: SELECT * FROM searchmysql error: Server shutdown in progressmysql error number: 1053Date: Thursday 02nd of January 2003 10:28:27 AMScript: http://www.paintball-forum.com/forum/forum/admin/backup.phpReferer: <A href="http://www.paintball-forum.com/forum/admin/backup.php">http://www.paintball-forum.com/forum/admin/backup.php

How can I fix these errors? I have just now diabled the search function, thinking it may be a part of it. Why would the forum connect but not disconnect from the mysql server as forsite.com suggests? I have persistent connections set to 1, but also got the same errors when I tried setting persistent connections to 0.

[Steve Machol]

First of all, your host really should upgrade PHP. They are runnng a badly outdated and buggy version.

Second, the server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off in your config.php:

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 0; 

But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow. It's also possible that your site is just too busy for a shared server.

[LCD_Angel]

Thanks Steve.

Okay... I have another question.

I have bought a new account at VenturesONline.com V500 (500 mb space). I know a lot of guys recommend them so I need to move my info to their server. Do you guys (vbulletin) offer server transfer services? I am assuming the standard $150 would be the charge. Please let me know.

Thanks

Mark

[Steve Machol]

Actually we do not have an official transfer server. However moving servers is easy to do if you have shell access (telnet or ssh) at both server. The instructions are here:

http://www.vbulletin.com/manual/movingservers.html

[LCD_Angel]

Originally posted by Steve Machol
Actually we do not have an official transfer server. However moving servers is easy to do if you have shell access (telnet or ssh) at both server. The instructions are here:

http://www.vbulletin.com/manual/movingservers.html

Unfortunately I don't know anything about telnet or SSH. I am really more of a buisness operator than a webmaster. Do you know of anyone who would be able to offer this service?

[JasonP]

Originally posted by LCD_Angel
Unfortunately I don't know anything about telnet or SSH. I am really more of a buisness operator than a webmaster. Do you know of anyone who would be able to offer this service?

LCD, I just sent you an email through the board, I can help you. Let me know.

Jason.