[Koha] Koha slowness and server hardware

[Robin Sheat]

Steven Nickerson schreef op wo 16-07-2014 om 13:32 [-0400]:

> -          Could it be the 32-bit OS?   The version of VMware I installed
> wouldn't allow me to create a 64-bit Debian VM.

It could be, but it's probably not with that number of items. 64-bit is
recommended however, and can be done with other virtualisation systems,
for example KVM or Xen.

> -          Are there any MySQL tuning parameters I should consider?

Yes. There's too much to get into via email, but make sure that mysql
has enough memory to cache the entire database into RAM, that your query
cache is large enough, and so on. There are plenty of articles and
helper scripts around for this.

> -          Any other thoughts/ideas on what I should look at?

Turn on the MySQL slow query log: that'll tell you what _actually_ is
taking the time. It might be that for some reason one of your tables
doesn't have an index that it should, and so queries are slower than
they should be. Also, disk IO can sometimes be a bit weird under
virtualisation, make sure that your disk access is at an appropriate
speed, although caching the whole thing in MySQL should make that less
important.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF