* Marc Balmer (marc@msys.ch) 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