[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