[Koha-devel] performance issues with mysql and koha on 2 physical servers

[Chris Cormack]

* Marc Balmer (marc at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: </pipermail/koha-devel/attachments/20120330/40183135/attachment.pgp>