[Koha] Koha instance with over 86 000 item records is been slow

[Robin Sheat]

amutsikiwa at 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