[Koha] Regular performance problems

[Chris Hobbs]

  On 3/14/11 10:23 AM, LAURENT Henri-Damien wrote:
> Le 14/03/2011 18:09, Chris Hobbs a écrit :
>> OK, any ideas? Other troubleshooting info I can provide? It's gotten to
>> the point that we're losing a decent amount of time every day to this issue.
> Innodb file management is quite important for performance.
> We wrote a performance blog post
> http://www.biblibre.com/en/blog/entry/mysql-default-config-and-very-large-koha-database
> you might find it interesting.
> Also, you should check that your kernel is at least bigmem enabled.
> Last but not least, check that you are not sending too many queries at
> once. We had that problem once. Solution could be to use a firewall to
> block more than 10 requests of the same page from same ip in a short
> amount of time (say less than 3 second for instance)
> There also has been an interesting discussion on performance tweeking on
> apache on list
> http://www.mail-archive.com/koha-devel@lists.koha-community.org/msg00074.html
> Hope that helps
Henri,

Thanks so much for the pointers. I was able to implement all of the DB 
suggestions, moved the zebra indexes to another disk, and configured 
mod_perl. Performance seems to have improved, and I'm hoping to make it 
through the rest of the day without more stalls.

-- 
Chris Hobbs
Director, Technology
New Haven Unified School District

--
This message was scanned by ESVA and is believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110314/c76f75bb/attachment.htm