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]

Reply via email to