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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers@biblibre.com