[Koha] Koha slowness and server hardware

[Daniel Sanford]

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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>