How to fix this problem? Tons of sql error emails last 2 days. no changes lately.

[whatsthegoodwor]

I haven't made any changes to my forum in months but the last 2 days I've been getting hundreds of sql errors. Have about 20 members online, 300 guests at a time, 45,000 posts over a few years. Shared hosting, they told me 30 max connections at any one time. Persistent connections is set to 0 (off).

Here are my list of mods:
vbseo and sitemap generator
passivevid
perforum max/min characters
auto database backup

They told me that this line is taking longer than a minute to execute

SELECT * FROM datastore WHERE title IN
('','options','bitfields','attachmentcache','forum cache','usergroupcache','style cache','la nguagecache','products','pluginlist','cron','profi lefield','loadcache','noticeca che','smil iecache','bbcodecache','mailqueue','bookmarksiteca che')

I'm also getting

mysql_connect() [<a
href='function.mysql-connect'>function.mysql-connect</a>]: User
k8mk4s_mtd already has more than 'max_user_connections' active connections.................forum/includes/class_core.php on line 311

Invalid SQL:
DELETE FROM posthash
WHERE dateline <
1322598396;
MySQL Error : MySQL server has gone away

Invalid SQL:
UPDATE session
SET lastactivity = 1322600306, location =
'/forum/newreply.php?do=newreply&noquote=1&p=2400', badlocation = 1
WHERE sessionhash = '09fc5816fd7cb666b804394795f07f85';
MySQL
Error : MySQL server has gone away

Please let me know how to fix this? The host told me what line is causing the problem but I have no idea how to fix it.

[Lynne]

If they aren't willing to raise their limit of persistent connections for you, then there is nothing you can do unless you choose to change hosts.

"MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: https://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265 You will need to talk to your host about this in order to get it resolved.

[whatsthegoodwor]

If they aren't willing to raise their limit of persistent connections for you, then there is nothing you can do unless you choose to change hosts.

"MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: https://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265 You will need to talk to your host about this in order to get it resolved.

They said that I could add memory to my package and run my own instance of SQL. Would 40 mb be enough? How much work is it to run your own SQL? I don't know much about server management, I have always just used shared hosting.

[Lynne]

Would 40mb be enough for what? As for running your own instance of mysql, I have no idea what they expect you to do there. You should ask them exactly what responsibilities they expect you to have in regards to your own SQL.