[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:09:13 CET 2014


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

--- Comment #10 from Frédéric Demians <frederic at tamil.fr> ---
> 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.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list