Nils Meyer wrote:
Hi Faygal,
Fagyal Csongor wrote:
for (1..50000) {
$dbh = DBI->connect($dsn, $user, $password, {'RaiseError' => 1} );
my $sth = $dbh->prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight on that topic:
http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/
Don't be confused with the PHP mentioned, the first paragraphs apply
to TCP/IP and mysql as whole.
regards
Nils
Thanks, Nils.
Actually I got to the same conclusion, too... when this error appears, there are something
like 15000 TCP connections around, mostly in "TIME_WAIT". Too bad these
connections linger around even after an explicit ->disconnect().
I should be using a persistent connection anyway :)
- Csongor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]