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

* Claire Hernandez (claire.hernandez@biblibre.com) wrote:

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?)

Unlikely

- mysql setting?

Possible, I would run mysqltuner on the database server and follow its' suggestions.

- network setting?

Also possible. I would test for network latency, (often failing reverse dns can introduce this) or simple packet loss. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand