[Koha] Koha slowness and server hardware

[Steven Nickerson]

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