I have many sites accessing one MySQL server, all using the same IP,
username, password via a PHP $connection = mysql_connect($ip,$user,
$pass);.
The server is extremely busy, hammered 24x7, but almost all traffic
is coming from one very short script. About once a day we're getting
"No database selected" with that one table "busy" and the only way
out is mysqladmin flush-hosts.
In that one busy script, I replaced mysql_connect() with
mysql_pconnect() according to some advice I received, and the server
immediately went back to "No database selected" and all hung up.
Everything I read seemed to indicate that what I did should have made
things better, not worse. Can someone suggest what my next steps
should be?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]