http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974
--- Comment #9 from Olli-Antti Kivilahti <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
