http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974 --- Comment #9 from Olli-Antti Kivilahti <olli-antti.kivilahti@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.