Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: jump.cgi - too many connections?

Quote Reply
Re: jump.cgi - too many connections? In reply to
Hi,

Are you sure the server you are running 'mysqladmin proc' is the one that is running Links SQL? If so, then try a test to see how many connections it can really hold:

Code:
use DBI;
while (1) {
push (@dbhs, DBI->connect('DBI:mysql:YOURDB:localhost', 'YOURUSER', 'YOURPASS', { RaiseError => 1 }));
$count++;
}
END {
print "Got: $count connections ok\n";
foreach my $dbh (@dbhs) { $dbh and $dbh->disconnect; }
}
and see if it really can hold 100 connections (note: connections get immediately released so this won't harm the server).

Cheers,

Alex

--
Gossamer Threads Inc.
Subject Author Views Date
Thread jump.cgi - too many connections? ethan 4358 Nov 29, 2000, 9:30 PM
Thread Re: jump.cgi - too many connections?
pugdog 4269 Nov 29, 2000, 9:52 PM
Thread Re: jump.cgi - too many connections?
ethan 4287 Nov 29, 2000, 10:59 PM
Post Re: jump.cgi - too many connections?
pugdog 4269 Nov 30, 2000, 4:44 PM
Thread Re: jump.cgi - too many connections?
Alex 4282 Nov 30, 2000, 5:04 PM
Thread Re: jump.cgi - too many connections?
ethan 4256 Nov 30, 2000, 5:22 PM
Thread Re: jump.cgi - too many connections?
Alex 4239 Nov 30, 2000, 5:31 PM
Thread Re: jump.cgi - too many connections?
ethan 4258 Nov 30, 2000, 5:50 PM
Thread Re: jump.cgi - too many connections?
Alex 4263 Nov 30, 2000, 5:58 PM
Thread Re: jump.cgi - too many connections?
pugdog 4289 Dec 1, 2000, 4:33 AM
Post Re: jump.cgi - too many connections?
ethan 4276 Dec 1, 2000, 7:32 AM
Thread Re: jump.cgi - too many connections?
pugdog 4259 Nov 30, 2000, 5:30 PM
Post Re: jump.cgi - too many connections?
Alex 4287 Nov 30, 2000, 5:33 PM