At 0:09 Uhr -0400 15.8.2001, Hans Zaunere wrote:
>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.
I've seen this too, the mysql command line client connects to the
unix socket also if given 'localhost' as host. Don't know about
DBD::mysql.
>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.
Your problem probably was not running out of file descriptors, but
running out of port numbers. Since every inet port (2^16 of them)
after close takes some time until it can be used again, there may be
no more free ports even if only few are actually in use concurrently.
This is the reason why I've suggested persistent connections.
christian.
---------------------------------------------------------------------
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
