* Marc Balmer ([email protected]) wrote: > Am 30.03.12 10:10, schrieb Claire Hernandez: > > Hello all, > > > > I would like to better understand why when we put koha source on a > > different mysql physical server we have a performance problems. > > > > If I put mysql on koha source server, an opac-search take 2 times less > > than if I separate mysql server and koha sources. > > > > I don't really know why: > > - perl libs? (CGI + DBH?) > > - mysql setting? > > - network setting? > > > > Do you know thinks about this? did you work or remember works from others ? > > > > (I am really not comfortable with hardware architecture or server > > settings and first I would like to collect your feedbacks.) > > When a server and client process are on the same machine, they can > communicate over a local socket (also called a Unix socket) which is a > lot faster than a TCP network socket which has to be used when the two > processes are on the same machine. > We run almost all our applications with dedicated database servers, including our Koha servers, but those database servers are specced to function fast as database machines. Quite a different profile to a web server.
Is your database server at least as powerful if not more powerful than the webserver? Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
signature.asc
Description: Digital signature
_______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
