MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Alec.Cawley Date:February 9 2005 1:30pm
Subject:Re: Performance of Sockets vs. TCP/IP connections on localhost?
View as plain text  
"Lasse Laursen" <laursen@stripped> wrote on 09/02/2005 13:24:27:

> Hi all!
> 
> Simple question: What is fastest when doing a connection to a local 
machine? 
> TCP/IP or connecting via the socket? the application is a ACL helper 
program 
> under Squid which makes a persistent connection to the database (100 
> parallel programs runs on the machine each connecting to the MySQL 
database)

From the Connector/J documentation:

"Named pipes only work when connecting to a MySQL server on the same 
physical machine as the one the JDBC driver is being used on. In simple 
performance tests, it appears that named pipe access is between 30%-50% 
faster than the standard TCP/IP access."

Alec Cawley
Thread
Performance of Sockets vs. TCP/IP connections on localhost?Lasse Laursen9 Feb
  • Re: Performance of Sockets vs. TCP/IP connections on localhost?Alec.Cawley9 Feb
  • Which version for fastest simple inserts, selects etcPete Lancashire23 Feb
    • Re: Which version for fastest simple inserts, selects etcJoerg Bruehe23 Feb
    • Re: Which version for fastest simple inserts, selects etcGleb Paharenko23 Feb