Mysql Warning: Too many connections

Webmasters:
If you have a web page related to this topic, Click here to Add Your Link.

Reply Your Comments:
Click this button if you are interested in replying to this topic and leave your comments

Sent To Friend
CLick this button if you want to send this page to a friend.

Subscribe to RSS
CLick this button if you want to subscribe to this RSS Feed. You can use your browsers feeds burners if you have mozilla or internet explorer 7 or higher and keep up with updates.

Forums Index
» MYSQL Forums
» » Mysql Warning: Too many connections

Mysql Warning: Too many connections
Post Description: mysql warning too many connections MYSQL
Post Tags:
This Post Has Been Viewed 288 Times Since Fri Jul 04, 2008 9:18 am Author justin with 2 replies

Mysql Warning: Too many connections

Advertise On This Page

for some reason im getting this error and i dont know what to do

i just moved my site to a dedicated server i thot it was going to be better but if this keeps up like this my wallpaper website will keep crashing

help, how can i stop this error from coming back again

UPDATE

ok i found the answer to this. i have red hat fedora core server so i logged in as root and send these commands:

Edit my.cnf file with your favorite editor, im using nano you can use vi if you prefer

nano /etc/my.cnf

now add this line under [mysqld] section

set-variable=max_connections=250

save the changes and then restart mysqld server:

/etc/init.d/mysqld restart

Done

Leave Your Comments

You Must Have Javascript Enabled to Submit This Form
Help: how to enable javascript

Subscribe [RSS]

Share this page by putting this URL in your comments to other websites like myspace, Facebook, Twitter friendster, Hi5, Groups, Boards, Forum or others. Just Copy and Paste this Code

URL:

To embed this topic, just copy the code from the "Embed" box. Once you've copied the code, just paste it into your website or blog to embed it.

Embed:

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin� and others. Just Copy and Paste this code on your Posts and Replies on your forums

BBCODE:

Webmasters - Exchange Links With Us. Add related websites to this topic

Links Related to : Mysql Warning: Too many connections

Comments and replies About Mysql Warning: Too many connections

:: 1 :: Reply #60315 Reply By hostman On Fri Jul 04, 2008 9:18 am

hostman:

If you get a Too many connections error when you try to connect to the mysqld server, this means that all available connections are in use by other clients.

The number of connections allowed is controlled by the max_connections system variable. Its default value is 100. If you need to support more connections, you should set a larger value for this variable.

:: 2 :: Reply #60316 Reply By hostman On Fri Jul 04, 2008 9:44 am

hostman:

you can also change the php.ini settings to:

A note por PHP developers. You can find this error if your scripts open persistent connections, wich aren't closed even if the script terminates. Use mysql_connect() instead of mysql_pconnect() unless you have a good reason. In particular, check this setting in third-party scripts (such as osCommerce).

Server administrators can disable persistent connections for PHP scripts in php.ini file:

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent=Off

Scripts won't fail, they'll just use non-persistent connections silently.

http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html