amutsikiwa@uzlib.uz.ac.zw schreef op di 22-10-2013 om 20:43 [+0200]:

I have a Koha instance with over 86 000 item records and is reported to getting somewhat slower especially in the circulation function. It is running on a server with 2.7 GHz processor and 2G RAM and running on Ubuntu. Is there a way of optimizing Mysql database?

How big is the database (in terms of size on disk)? Though, is it where the slowness is coming from? Are perhaps indices missing from tables somehow? What's the CPU and IO load on the server, and the typical memory use? What Koha version did you install? What are you currently running? How did you install it, packages, tarball, other? Cleaning out the database is possible with the cleanup_database.pl script (this runs daily automatically with the packages) however it probably won't help circulation speed significantly. There are some patches that need signing off that will help the performance of opac search, and this will help other aspects of the system too, so you could look into testing these: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11051 But really, the best way to be sure is to sit down with a profiler and see where exactly the time is being spent. Until you do this, everything is guesswork. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF