[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 18:33:27 CET 2014


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

--- Comment #11 from Olli-Antti Kivilahti <olli-antti.kivilahti at 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.


More information about the Koha-bugs mailing list