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
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
--
Fridolin SOMERS
Biblibre - Pôles support et système
[email protected]
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
