http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974 --- Comment #11 from Olli-Antti Kivilahti <olli-antti.kivilahti@jns.fi> --- (In reply to Frédéric Demians from comment #10)
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.
Practically, why did you need to use a non-standard socket? You just could have done a symbolic link. Do you have several DB servers running simultaneously on the same server?
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.
Yes, this magnitude of performance improvement is very interesting. But once again, we already have it using 'localhost' MySQL hostname.
Your code seems ok to my eyes, and could be integrated as it is, but we need to know in which situation your DB socket mode is required vs the localhost connection mode which has the same performance.
I am using this patch to share a unix socket between two LXC containers in a mounted "middle" partition. So I move the socket to the shared partition. I think this could also be achieved using a symlink, not sure. That was my initial idea but I had some issues moving the socket (and possibly due to unrelated issues) I failed to get the symlink version working. Give or take this feature will atleast be useful to someone running multiple databases on the same OS :) -- You are receiving this mail because: You are watching all bug changes.