What is this error

[werehere]

Well it was installed with no errors last night, and it ahs run for over a half a day running fine, and seemed fast enough, but all the sudden it became painfully slow, and finally this error:




Warning: Too many connections in /home/usr31/html/forums/admin/db_mysql.php on line 29

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.

Warning: Too many connections in /home/usr31/html/forums/admin/db_mysql.php on line 29

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.









So what does this mean?

[werehere]

Also the rest of the site is very fast right now, and no problems, however the forum is not able to be reached.


What should I do know?

Any suggestions?

[werehere]

Is case it helps, through telnet I get an error:

1040 to many connections

[werehere]

Here is what I get when connecting to phpMyAdmin:

Warning: MySQL Connection Failed: Too many connections in lib.inc.php3 on line 119
Error
MySQL said:
Back

[John]

This means that you have too many simultaneous users for MySQL to cope with its current settings. It possible to change the maximum connections allowed to a bigger value. Are you on a hosted site, or a dedicated server? If it is hosted, you will need to contact your host and ask them to increase the max_connections variable.

If it is a dedicated server, then you can do this yourself. I cannot recall the command off the top of my head, but I will post it tomorrow when I have it to hand.

John

[Aldreis]

> If it is a dedicated server, then you can do this yourself.

If it is true, werehere, could be helpful to take a look at this (http://www.mysql.com/php/manual.php3?section=Too_many_connections) page of the MySQL manual.

[werehere]

Thanks john, and yes it is a dedicated server.

It seems a little odd that it hit this funny spot where it just stopped completely. I know it can happen of course, but I would not expect it to just stop like that.


Have you had this problem, and how many concurent users would you guess it would take to do this?

[Brian]

It depends if you have it set to a low number then not many as each page has a lot of calls. So once you find out how increase it :)

[John]

I cannot remember how many users exactly it was that tipped it over - 100 is the default level. It is not just the forums that use MySQL on our server.

Now then, to increase the value, I think that this is what you do:


mysqld -o max_connections=800 &


I can confirm that tomorrow.

John

[Aldreis]

To modify MySQL server parameters look at this (http://www.mysql.com/php/manual.php3?section=Server_parameters).

[werehere]

Thank you everyone for your help:)

Ok, so I type that in exactely how you showed it john:

mysqld -o max_connections=800 &

and it gives me a command not found. Now can I use this like this

mysql -o max_connections=800 &

without the "d"? It seems to give me a command not found whenever I use the "d".


Thanks everyone, and Aldreis I found that link you gave me very helpful, and it sounds like exactely what I need, I just am still learning this, so any further help is very much appreciated:)

[shri]

Its in /usr/sbin/mysqld

[werehere]

Well I can telnet in and get the "mysqladmin variables" that do verify it is set to 100:


| max_connections | 100 |



I however only get a
bash: mysqld: command not found

when I use johns syntax. I am sure it is close to working, but it just wont take that for some reason. Anyone have any further suggestions for a MySQL beginner?:)