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. Careful tuning and refactoring of the SQL commands should minimize the effect, though. And when designed properly, a distributed application can actually be a lot faster, but this depends on the design (the key is that both parts, the DB and the application, can do some meaningful work in parallel, which, of course, is not the case when the application merely waits for the DB results). -mb