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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Mar 20 17:11:05 CET 2014


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

--- Comment #9 from Olli-Antti Kivilahti <olli-antti.kivilahti at jns.fi> ---
(In reply to Frédéric Demians from comment #8)
> Koha MySQL client is DBD::mysql module:
> 
>   https://metacpan.org/pod/DBD::mysql
> 
> See the 'port' argument of the 'connect' method:
> 
>   The hostname, if not specified or specified as '' or 'localhost', will
>   default to a MySQL server running on the local machine using the
>   default for the UNIX socket. To connect to a MySQL server on the local
>   machine via TCP, you must specify the loopback IP address (127.0.0.1)
>   as the host.

My feature is about using non-default unix socket for mariadb.
Try moving the mariadb/mysql socket to another path and then see what happens
with the localhost directive with perl DBI.

>> 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?

Good thing that you smelt something fishy :)

I stated that socket connections are _generally_ 30-40% faster which I got from
an obscure googling result. I haven't ran any tests with Koha because it is
obvious that sockets > TCP and the fix was rather easy to do.

petter from Oslo ran some tests and confirmed that you can get 0-20%
performance increase. But I can imagine the performance benefits on live
environment when doing checkouts for example.

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


More information about the Koha-bugs mailing list