From: Michael Widenius Date: April 17 1999 7:29am Subject: localhost/socket speeds List-Archive: http://lists.mysql.com/mysql/1978 Message-Id: <14104.14240.6038.843650@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Dave" == Dave writes: Dave> Anyone have any idea of speed differences between using a localhost Dave> connection and a socket for MySQL? I am contemplating setting up a dedicated Dave> MySQL machine for all our DB activity but if the other 4 machines are going Dave> to suffer by having to query across sockets I don't want that... Dave> Any comments are greatly appreciated. (even ones pointing me to a page in Dave> the MySQL manual) From the MySQL manual: ------ If you connect using TCP/IP rather than Unix sockets, the result is 7.5% slower. ---- On the other hand, you can easily test this yourself. Just run the MySQL benchmarks as follows: perl run-all-tests --host='your-host-name' --suffix=tcp_ip --small-tables perl run-all-tests --host='localhost' --small-tables perl compare-results output/RUN* Regards, Monty