<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle27
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Update and hopefully some new insight from you fine folks. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I got a little overzealous today and tried launching ~100 searches of the single book item. The server became basically nonfunctional. I DOS attacked myself…<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The server load jumped into the high 40s. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I noticed that the rebuild_zebra.pl kept popping up in the top output. Should this be running actively during searches? I thought it was just supposed to be run through cron jobs. The default cron jobs were setup by the installation and I verified they do exist. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The opac-search.pl is just killing the server, any ideas of what to look for would be greatly appreciated. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Anyone else out there running on esxi, if so any issues?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Jeremy<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> IBS Computer Support <br><b>Sent:</b> Thursday, October 27, 2011 10:44 AM<br><b>To:</b> 'Randall Rowe'; <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br><b>Subject:</b> RE: [Koha] Introduction and incredibly slow searches<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'>Uname:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Linux ibs-koha 2.6.32-5-686 #1 SMP Mon Oct 3 04:15:24 UTC 2011 i686 GNU/Linux<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Top:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>After reboot and server settle:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>top - 10:27:01 up 8 min, 1 user, load average: 0.00, 0.33, 0.32<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>During launch of 21 tabs searching links in single book listing:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>top - 10:30:30 up 12 min, 1 user, load average: 2.93, 1.37, 0.70<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Tasks: 131 total, 7 running, 124 sleeping, 0 stopped, 0 zombie<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Cpu0 : 71.8%us, 27.5%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.7%si, 0.0%st<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Cpu1 : 85.5%us, 13.5%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 1.0%si, 0.0%st<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Cpu2 : 78.9%us, 20.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 1.0%si, 0.0%st<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Cpu3 : 73.2%us, 25.8%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 1.0%si, 0.0%st<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Mem: 1034236k total, 217968k used, 816268k free, 6396k buffers<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Swap: 495608k total, 0k used, 495608k free, 75232k cached<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ P COMMAND <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1922 XXXXX 20 0 21316 15m 2988 R 83 1.5 0:03.14 1 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1917 XXXXX 20 0 26316 20m 3092 R 66 2.0 0:03.98 2 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1923 XXXXX 20 0 14120 8524 2644 R 52 0.8 0:01.83 0 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1921 XXXXX 20 0 16492 10m 2692 R 51 1.1 0:02.13 0 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1915 XXXXX 20 0 38832 31m 4652 R 40 3.1 0:07.00 1 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1925 XXXXX 20 0 10580 5336 2316 R 25 0.5 0:00.79 3 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1322 mysql 20 0 136m 28m 6044 S 10 2.8 0:17.13 3 mysqld <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1924 XXXXX 20 0 28736 3516 1356 S 5 0.3 0:00.15 1 zebrasrv <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1907 XXXXX 20 0 35460 5052 1180 S 3 0.5 0:00.37 3 apache2 <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1072 XXXXX 20 0 28232 4628 2764 S 1 0.4 0:00.88 2 zebrasrv<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The opac-search eventually start dropping off to be replaced with opac-detail:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ P COMMAND <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 2013 XXXXX 20 0 37256 29m 4268 R 75 2.9 0:05.29 3 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1995 XXXXX 20 0 38580 30m 4652 R 53 3.0 0:06.26 3 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 2011 XXXXX 20 0 32048 24m 3392 R 51 2.4 0:04.14 1 rebuild_zebra.p <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 2012 XXXXX 20 0 24552 18m 3056 R 50 1.8 0:03.35 0 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1993 XXXXX 20 0 38460 30m 4652 R 48 3.0 0:06.80 1 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1997 XXXXX 20 0 30872 24m 3420 R 48 2.4 0:04.67 2 opac-search.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1994 XXXXX 20 0 38900 30m 4368 R 47 3.0 0:07.14 2 opac-detail.pl <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 1322 mysql 20 0 136m 28m 6044 S 25 2.8 0:24.95 0 mysqld <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> 2014 XXXXX 20 0 28732 3508 1356 S 4 0.3 0:00.11 1 zebrasrv <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>2015 XXXXX 20 0 28736 3512 1356 S 2 0.3 0:00.05 3 zebrasrv <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Jeremy<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Randall Rowe <a href="mailto:[mailto:r.rowe@lincolnlibraries.org]">[mailto:r.rowe@lincolnlibraries.org]</a> <br><b>Sent:</b> Thursday, October 27, 2011 10:08 AM<br><b>To:</b> ibs computer support; <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br><b>Subject:</b> Re: [Koha] Introduction and incredibly slow searches<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Is top showing that you really are using the 4 CPUs available?<br>Pressing the numeral 1 will toggle multiple CPU lines in top.<br>To display the CPU a program is running on first press 'f' then 'J' to add the CPU in use column (P) to top's display.<br>What is your load average?<br><br>Does 'uname -a' show that you're running the SMP version of Debian?<o:p></o:p></p><p style='margin-bottom:12.0pt'>Randy Rowe<br>Lincoln City Libraries I.T.<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br><br><br><o:p></o:p></p></div></body></html>