<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
Our koha server regularly grinds to a halt, preventing use of the
web gui and even making it near impossible to log into via ssh. One
minute load average on the server has spiked into at least the 80s,
where it normally hovers around 1. <br>
<br>
If I'm patient, after about 15 minutes the system becomes usable
again. <br>
<br>
Where should I begin looking for the trouble? <br>
<br>
The system is running on a VMWare ESX host. It's been given two
vCPUs and 6GB of RAM. The host is not starved for resources, so I
think I can exclude it from the equation. Other VMs running on the
same host are not affected. <br>
<br>
Koha is version 3.01.00.140 (last beta before 3.2). The server is
Ubuntu 9.10. We have ~200,000 items and ~100,000 biblios. <br>
<br>
I was able to capture a process list during the last event (this
AM), and saw that I had 95 instances of apache started. At the
moment, with things working smoothly, I have only 14. <br>
<br>
I've also run mysqltuner.pl in order to locate potential bottlenecks
with the db, and the only glaring issues I have are:<br>
<br>
1) Lots of joins without indexes (811 since db restart this morning)<br>
2) Temporary tables created on disk: 45% (6K on disk / 15K total)<br>
I've set innodb_buffer_pool_size = 1G in my.cnf, but still the
system keeps creating these tables on disk, which certainly can't be
helping anything.<br>
<br>
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.<br>
<br>
Thanks so much in advance!<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>