More Board Errors for Troubleshooting Gurus

[Zenon]

The boards have seemed to be slowing down all day for me. Finally, in mid-afternoon (EST) some errors:

Connecting to a news item off of the main EnWorld page (www.enworld.org):

"Warning: Too many connections in /http/forums/news/pnadodb/drivers/adodb-mysql.inc.php on line 121

Warning: MySQL Connection Failed: Too many connections in /http/forums/news/pnadodb/drivers/adodb-mysql.inc.php on line 121
mysql://rootlocalhost/Rogue failed to connectToo many connections"

Attempting to click on the messageboard link off of the main page:

"Warning: Too many connections in /http/forums/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Too many connections in /http/forums/admin/db_mysql.php on line 40

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience."

Hope this helps!

 

[Mr Fidgit]

Attempting to click on the messageboard link off of the main page:

"Warning: Too many connections in /http/forums/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Too many connections in /http/forums/admin/db_mysql.php on line 40

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience."

i've gotten this same thing a few times today, and more over the last few days. (i've had connection problems lately, so i thought maybe it was just me...)

 

[Psionicist]

To Morrus, or any other admin:

1) Remote access the messageboard server
2) Open up a console
3) Write mysqladmin flush-hosts

This will fix things temporarly. For a more permanent solution, do something like this

1) Remote access your server
2) Open up a console
3) write mysqladmin variables . This will show you your mysql settings.
4) Look for the "max_connections" string and remember the number. It will look something like this:
max_connections current value: 100
in this case, remember 100.
5) write safe_mysqld -O max_connections=XXX
where XXX is a number larger than before. If the max_connections value used to be 100, set it to 130. Add 30% or so.

Try it.

 

[Mr Fidgit]

ok, how about this one...(and please keep in mind, i don't know anything about computers)

i've never had to log in on the message boards since registering.

i've also had the same highlighted thread/ticker problem

out of nowhere, just a few minutes ago, the highlights were back, the ticker was back, but i wasn't logged in

and this happened while i was on the boards

what's up with that?

 

[Morrus]

1) Remote access your server
2) Open up a console
3) write mysqladmin variables . This will show you your mysql settings.
4) Look for the "max_connections" string and remember the number. It will look something like this:
max_connections current value: 100
in this case, remember 100.
5) write safe_mysqld -O max_connections=XXX
where XXX is a number larger than before. If the max_connections value used to be 100, set it to 130. Add 30% or so.

Yeah, I already sent cyberstreet an email asking them to increase it - it's set at 100.