[Koha] Koha slowness and server hardware

[Fridolin SOMERS]

Hie,

We know the disk IO performance can be very bad on VMware. It will set 
MySQL slower.
Consider using sysbench to mesure the performance : 
https://packages.debian.org/wheezy/sysbench

For MySQL : you will be given advices by http://mysqltuner.com/.

Personnaly, we use LXC as virtualizer, its awsome.

Best regards,

Le 16/07/2014 19:32, Steven Nickerson a écrit :
> Hello everyone,
>
>     I'm looking for some thoughts/opinions.   I have a working 3.14.04
> "package install" environment running on a 4-core 3.6GHz system with 8GB
> RAM.  The OS is Debian 32-bit running as a VM on top of VMware ESXi.  This
> single VM is allocated pretty much all of the physical hardware resources in
> the system...just wanted the flexibility of adding a "test" VM environment
> later perhaps.   We are noticing that most functions are quite slow,
> including check-ins, check-outs, and patron lookups.   I've monitored the
> system for a bit and am seeing that mysqld is consuming 100% of all 4 CPUs
> consistently during the slowness.   What I'm wondering is:
>
> -          Does this seem normal to folks?  Should a relatively small
> environment (less than 2000 patrons and just over 11,000 items) be consuming
> that much CPU?
>
> -          Could it be VMware?
>
> -          Could it be the 32-bit OS?   The version of VMware I installed
> wouldn't allow me to create a 64-bit Debian VM.
>
> -          Are there any MySQL tuning parameters I should consider?
>
> -          Any other thoughts/ideas on what I should look at?
>
>
>
> Thanks all!
>
> Steve
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 
Fridolin SOMERS
Biblibre - Pôles support et système
fridolin.somers at biblibre.com