> > > > my $dbh = connect("DBI:mysql:database:localhost", "user",
> "password");
Well I uncovered an interesting thing. If I use the regular old
bin/mysql client to connect to the database (both on the same machine)
and I run: ./mysql -uroot -p -h localhost
Then run netstat -an , it shows that another /tmp/mysql.sock instance
is connected, while the original /tmp/mysql.sock is ofcourse still
listening.
And I was thinking, since a socket is a socket (just a file descriptor)
whether local sockets or INET socks are getting used up, ssh still
wouldn't work.
Does anyone have info on how good the Linux kernel is at handling local
UNIX sockets vs. INET sockets?
Thank you,
Hans
[EMAIL PROTECTED]
> Well it seems like you ARE using INET TCP/IP sockets, since there
> is
> 'localhost' there (which goes over the loopback device). Not sure
> however if this syntax for specifying the host is correct, it's
> not
> mentioned this way in man DBD::mysql.
>
> And if you were running out of INET sockets so you couldn't
> connect
> with ssh anymore, it MUST have used INET sockets, doesn't it?...
>
> So try to strip this :localhost off.
>
> You could also use some persistent connection mechanism so that
> the
> script doesn't reconnect on each request.
>
> chj
>
> -------------------------------------------------------------------
> --
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <mysql-unsubscribe-
> [EMAIL PROTECTED]>Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php