That number does seem usual. We've got a Koha instance that's larger in terms of items (small in terms of patrons) which gets a much lower usage. It's possible that a lot of searches or use could drive it up but that tends to be spikes rather than a long flat usage. VMware is a possible cause. The first thing I'd do is check your ESXi settings to see how much RAM and CPU you've allotted to your virtual machine. If your allotment for the VM is unusually low your virtual machine might be starved for resources. Also if you've assigned over 4 GB of RAM to this VM you're wasting it since a 32 bit OS will be capped at 4 GB of usable RAM. If you're still seeing high usage, inside MySQL try running a SHOW PROCESSLIST; to see what's going on when you see that 100% CPU use. There could be a background job that is stalling for some reason when other activity happens. Daniel Sanford On Wed, Jul 16, 2014 at 1:32 PM, Steven Nickerson <snicker1@maine.rr.com> wrote:
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