[Koha-bugs] [Bug 11974] Enable unix socket connections for database connections.

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974

Frédéric Demians <frederic at tamil.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |frederic at tamil.fr

--- Comment #7 from Frédéric Demians <frederic at tamil.fr> ---
(In reply to Olli-Antti Kivilahti from comment #4)

> Using unix sockets is generally ~30-40% faster compared to using TCP
> packets.  Because Koha abuses the database a lot, this will make a
> difference.

Are you sure? Do you have figures to prove that Koha is faster using
your patch socket-mode?

By default, Koha access MySQL server via localhost. My understanding is
that localhost means that communication with MySQL server is done via
socket (/var/run/mysqld/mysqld.sock on Debian). Take a look here:

  http://dev.mysql.com/doc/refman/5.0/en/connecting.html

Specifically this sentence:

  On Unix, MySQL programs treat the host name localhost specially, in a
  way that is likely different from what you expect compared to other
  network-based programs. For connections to localhost, MySQL programs
  attempt to connect to the local server by using a Unix socket file.

-- 
You are receiving this mail because:
You are watching all bug changes.