<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 3/14/11 10:23 AM, LAURENT Henri-Damien wrote:
<blockquote cite="mid:4D7E4F2B.6070806@biblibre.com" type="cite">
<pre wrap="">Le 14/03/2011 18:09, Chris Hobbs a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap="">
Innodb file management is quite important for performance.
We wrote a performance blog post
<a class="moz-txt-link-freetext" href="http://www.biblibre.com/en/blog/entry/mysql-default-config-and-very-large-koha-database">http://www.biblibre.com/en/blog/entry/mysql-default-config-and-very-large-koha-database</a>
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
<a class="moz-txt-link-freetext" href="http://www.mail-archive.com/koha-devel@lists.koha-community.org/msg00074.html">http://www.mail-archive.com/koha-devel@lists.koha-community.org/msg00074.html</a>
Hope that helps
</pre>
</blockquote>
Henri,<br>
<br>
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. <br>
<br>
<div class="moz-signature">-- <br>
<font color="blue">Chris Hobbs</font><br>
Director, Technology<br>
New Haven Unified School District</div>
--
This message has been checked by ESVA and is believed to be clean.
</body>
</html>