Can't connect to MySQL server on 'server_IP' (99)

Steele · #1 (**permalink**) 09-06-09, 15:37

Hello,

My website resides on one server and it connects to a remote MySql server.

Intermittently, I am getting following error:

--------------------------------------------------------
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL
server on 'server_IP' (99) in /home/user/public_html/include/db.inc.php on
line 18
Can't connect to MySQL server on '10.78.41.155' (99)
--------------------------------------------------------

Line 18 contains connection to the DB server:

$db_h = mysql_connect(DB_HOST, DB_USER, DB_PASS)

This error comes up randomly, but definitely a lot more during the times when the website traffic is heavier and more users are browsing the site.

I searched everywhere but so far did not figure it out...

Any ideas?

Thanks!

healdem · #2 (**permalink**) 09-06-09, 16:00

so what was the MySQL error.
I'm guessing its going to be something like
"to many connections"

PHP Code:


			
$cnn=@mysql_connect(HOST,UID1,PWD1) or die(echo mysql_errno().": ".mysql_error());
$dbr=@mysql_select_db(DBN,$cnn) or die (echo mysql_errno().":".mysql_error());
$strSQL = "select my,column,list from mytable"; 
$ResultSet=@mysql_query($strSQL,$cnn) or die (echo mysql_errno().": ".mysql_error()." SQL is":.$strSQL));

mnirwan · #3 (**permalink**) 09-06-09, 18:16

When that happens, try to login to shell and type netstat -n. If you get a lot of open connection in TIME_WAIT status, it may be due to you running out of outgoing port.

Check this link : MySQL Lists: mysql: Re: error 99(?) : can't connect to MySQL server.

You may want to try some kind of DB connection pooling or change it to mysql_pconnect() instead of mysql_connect().