<!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 text="#000000" bgcolor="#ffffff">
On 3/14/11 10:23 AM, LAURENT Henri-Damien wrote:
<blockquote cite="mid:4D7E4F2B.6070806@biblibre.com" type="cite">
<pre wrap="">Hi
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.
</pre>
</blockquote>
<blockquote cite="mid:4D7E4F2B.6070806@biblibre.com" type="cite">
<pre wrap="">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>
</pre>
</blockquote>
Just wanted to say thanks again to Henri, as well as to Cindy
Murdock and Mason James in the linked e-mail exchange.<br>
<br>
They say a picture is worth a thousand words. Here's the performance
graphs of our server over the last 30 hours. The three spikes in the
first graph each represent about 15 minutes of the system being
completely unusable. After the third spike I took the web server
down and got the database fixes implemented, and moved the zebra
indexes to another disk. At about 2:30pm Monday I turned on mod_perl
and you can see the result of that in the CPU Utilization graph
(it's the cliff).<br>
<br>
Today was a much better day :-)<br>
<br>
Here's the picture: <a class="moz-txt-link-freetext" href="http://www.clanhobbs.org/moz-screenshot-2.png">http://www.clanhobbs.org/moz-screenshot-2.png</a><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>