How to handle the "many connections -mysql_connect"

I have received the following error in loading my site:

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/vtc/domains/v1000.org/public_html/settings.php on line 10
Too many connections

Any solution to fix it ?

 

increase the connections in /etc/my.cnf

max_connections=1000

 

Thanks.
REP was given

 

Most welcome!

 

Why not use mysql persistent connections?

mysql_pconnect()

 

can you tell me how to do ?
I cannot find the file /etc/my.cnf

 

mysql_pconnect() is a php function that will replace mysql_connect() in the script. I would suggest agsinst using persistent connections as it will increase the amount of memory used by mysql.

The location of my.cnf will vary, it can even go by different names. The easiest way to find it is to do a search on the computer for it.

Run this command as a super user (root) or via sudo.

find / | grep my.cnf

Code (markup):

This should tell you the location of any file called my.cnf. Find / will list every single file on the computer. | grep my.cnf pipes that data through grep which limits the output to anything with the name my.cnf.

If it is called that name it will be found. If for some reason it is named something else, it is probably my.conf

find / | grep my.conf

Code (markup):

You could also use the locate command, but that requires a database to be updated and I find it to not be worth the resources.

 

I have following error ?

login as: root
root@64.'s password:
Last login: Mon Oct 1 10:30:44 2007 from 218.
[root@64 ~]# find / | grep my.cnf
find: WARNING: Hard link count is wrong for /proc: this may be a bug in your fil esystem driver. Automatically turning on find's -noleaf option. Earlier result s may have failed to include directories that should have been searched.
find: /proc/19255: No such file or directory
find: /proc/19257: No such file or directory
find: /proc/19259: No such file or directory
find: /proc/19265: No such file or directory
find: /proc/19266: No such file or directory
/etc/.my.cnf.swp

 

For redhat based os try :

# updatedb
# locate my.cnf
# locate my.conf

BTW, for dedicated server/VPS, using pconnect shouldn't be a big issue...provided your script supports.
Scripts like vbulletin has option to use pconnect or mysqli to maximize performance.

 

[root@64 ~]# updatedb
[root@64 ~]# locate my.cnf
/etc/.my.cnf.swp
[root@64 ~]# vi /etc/.my.cnf.swp
[root@64 ~]#


Still no idea how to do

 

This tells me that your my.cnf file has gone missing for some reason. You should create a new one. The contents of this file will vary depending on your server, I would suggest taking a look around the forum as there are quite a few good posts on the subject.

 

so bad.

anybody can help me ?

 

Why not asking for his current/max RAM first ?

He might not be able to handle those 1000 connections simultaneously

persistent connections can kill the machine if not limited

 

How do I create the /etc/my.cnf myself?
what is the correct content inside this file ?

 

Below is the my.cnf from my server. I've tweaked this file a ton to get it working just right for my VPS with 256mb of ram. I know for a fact that this file will not work for many people as it is set for my specific server.

[mysqld]
skip-networking
skip-innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 500
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 8M
max_connect_errors = 10
key_buffer = 48M
max_connect_errors = 10
key_buffer = 16M
query_cache_limit = 1M
query_cache_size = 6M
query_cache_type = 1
table_cache = 128

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192

Code (markup):

 

Thanks to Chicken. REP was given.

Can anyone tell me how to customize it to a P4 3G server with 1G RAM ?

 

please try my setting:

 

Thank you very much

 

Just letting you know that those numbers can't be ideal for every machine - tweak it yourself by changing individual variable every time and notice the server performance in peak hours until you get to the figures that work for you the best.

 

any tips to optimize this setting ?

Thanks anyway