TCP/IP Sockets, UNIX Sockets
How do you force mysql to use either TCP/IP Sockets or UNIX Sockets? And how do you know which one it uses? It is for a performance analysis. Thanks! Daniel Åkerud
Re: TCP/IP Sockets, UNIX Sockets
At 9:04 PM +0200 6/22/01, Daniel Åkerud wrote: How do you force mysql to use either TCP/IP Sockets or UNIX Sockets? And how do you know which one it uses? It is for a performance analysis. Thanks! Daniel Åkerud If you connect to localhost, MySQL will use a UNIX socket if possible. If you connect to 127.0.0.1, MySQL will use a TCP/IP connection. If you connect to a remote host, TCP/IP is always used. -- Paul DuBois, [EMAIL PROTECTED] - 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
Re: TCP/IP Sockets, UNIX Sockets
Hi. On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote: How do you force mysql to use either TCP/IP Sockets or UNIX Sockets? And how do you know which one it uses? localhost uses UNIX sockets, hostname uses TCP/IP sockets. You can indirectly determine what connection was used by running SELECT USER(); and looking whether you are considered to come from localhost or from hostname. Bye, Benjamin. - 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