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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha