vBulletin DB Errors recently
 

I've been getting a few of these recently, but didn't happen much before. Travel has remained mostly constant for the last year so not sure why it is happening now:
I contacted my host about this and they replied with this:
Any ideas how to fix this? Do I need to add more memory or there another solution? I'm running vB 4.2.1 and have been pretty much since it came out. And here are the versions of Apache, PHP, and mySQL:
Apache version 2.2.21
PHP version 5.2.17
MySQL version 5.1.73-cll

Thanks.

You should update MySQL, however, according to that free, you have 1.7gb of free memory, and are only using 700mb.

You should reduce the number of connections though, chances are you don't need 500.

the line 317 is to do with the username and password in your config.php

Yeah, well, of course you need username and password to connect to the database, that's the whole point of it. But what does that have to do with the error of the OP? He does not have a password or username issue.

The error is just stating MySQL can't connect, the error lines from the software are pretty pointless.

Pointing out what the line in that php means. Just because I pointed it out it does not mean this is the problem he is getting

I will update it. However, if that isn't the issue, what is causing all these errors?

Why can't it connect?

Thanks for your help, much appreciated.

Don't know, that error generally emans MySQL is down, or otherwise unreachable.

Aside from upgrading, what can be done to resolve this? Getting a lot lately. Thanks.

Are you running on a dedicated server or shared webhosting?

Running on a VPS, which has worked fine for years and there isn't any increase in traffic.

Running MySQL 5.6 now, with vB 4.2.1. Any other ideas to look into would be appreciated.

Thanks.

--------------- Added [DATE]1406278992[/DATE] at [TIME]1406278992[/TIME] ---------------

We got about 12,000 more of these errors in the last 24 hours.

We've upgraded MySQL as recommended, what more can we do? Traffic has stayed relatively the same over the last few months, but this last month we've got tons of these "too many connection" errors.

Any idea why this is happening now? Is adding more RAM the only option?

Thanks.

bump. The innodb or ibdata1 file seem to be massive (according to what my server support says), I think during the upgrade (though not sure, just didn't have space issues before). It is now causing our server to fill up and throw a bunch of errors. I'm looking to hire a developer to resolve these issues related to this.

Any help would be much appreciated.

Thanks.

I would suggest you post in the Server Configuration forum on vbulletin.com and then George can tell you which mysql variables to change.