<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.EmailStyle25
{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'>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 [mailto:r.rowe@lincolnlibraries.org] <br><b>Sent:</b> Thursday, October 27, 2011 10:08 AM<br><b>To:</b> ibs computer support; koha@lists.katipo.co.nz<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?<br><br><o:p></o:p></p><p style='margin-bottom:12.0pt'>Randy Rowe<br>Lincoln City Libraries I.T.<br><br><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br><br>-----Original Message-----<br>From: "IBS Computer Support" <<a href="mailto:ibssupport@Colorado.EDU">ibssupport@Colorado.EDU</a>><br>Sent 10/27/2011 10:35:36 AM<br>To: "Randall Rowe" <<a href="mailto:r.rowe@lincolnlibraries.org">r.rowe@lincolnlibraries.org</a>>, "ibs computer support" <<a href="mailto:ibssupport@colorado.edu">ibssupport@colorado.edu</a>>, "<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>" <<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>>, "Chris Cormack" <<a href="mailto:chris@bigballofwax.co.nz">chris@bigballofwax.co.nz</a>><br>Subject: RE: [Koha] Introduction and incredibly slow searches<span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>To answer the questions from Randy and Chris and add more 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'>Koha was installed following these directions:<o:p></o:p></span></p><p class=MsoNormal><a href="http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze">http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze</a><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>and the install notes towards the bottom of this page starting at “Step: Install Koha”<o:p></o:p></span></p><p class=MsoNormal><a href="http://wiki.koha-community.org/wiki/Setting_Up_Koha_in_Virtual_Environment_%2B_Using_That_as_a_Development_Environment">http://wiki.koha-community.org/wiki/Setting_Up_Koha_in_Virtual_Environment_%2B_Using_That_as_a_Development_Environment</a><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The server is a virtual machine on ESXi v4.1.<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'>It is the only virtual machine on the host ESXi server. <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'>It has 4 CPUs dedicated to it, as well as 1GB RAM<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'>Watching “top” it doesn’t use enough RAM to get to need to swap<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 shows:<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'>opac-search.pl for however many tabs I open from the initial search screen<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'>followed up with <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'>opac-detail.pl<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'>ping requests are <1ms<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'>Machines are on the same physical network, just different subnets. <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 windowtext 1.0pt;padding:3.0pt 0in 0in 0in;border-color:-moz-use-text-color -moz-use-text-color;-moz-border-top-colors: none;-moz-border-right-colors: none;-moz-border-bottom-colors: none;-moz-border-left-colors: none;-moz-border-image: none'><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></strong><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><strong><span style='font-family:"Tahoma","sans-serif"'>Sent:</span></strong> Thursday, October 27, 2011 5:47 AM<br><strong><span style='font-family:"Tahoma","sans-serif"'>To:</span></strong> ibs computer support; <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br><strong><span style='font-family:"Tahoma","sans-serif"'>Subject:</span></strong> 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'>What version of koha are you running? Where did you download it?<br>I noticed that you went "through the examples on liblime.com".<br>If that is where you downloaded koha then you are not running the community version of koha.<br><br>Regardless of what koha you are running, check the output of the command "top".<br>That should give you an idea of what is taking up time in the process.<br><br>Are all these machines on a local network? Is ping response between the machines reasonable?<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>-----Original Message-----<br>From: "IBS Computer Support" <<a href="mailto:ibssupport@Colorado.EDU">ibssupport@Colorado.EDU</a>><br>Sent 10/26/2011 3:47:54 PM<br>To: "<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>" <<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>><br>Subject: [Koha] Introduction and incredibly slow searches<span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal>Hello Everyone, <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>New to the list, new to Koha, increasingly frustrated :}<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve built a koha server for our in-house library which seems to have gone over fine but I’m having issues with incredibly slow search response. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m running the latest stable koha-common 3.6 (updated a few minutes ago) on Debian 6.0.3. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have successfully entered in a record for one book. When I search from the initial koha page it takes ~4 seconds to find this item. Then once the item has loaded if I click one of the links for a searchable item (author, details, etc.) it takes ~4-5 seconds for it to load. When I open all of these options at the same time in new tabs it takes forever. It seems to be an almost linear increase in the time it takes for the searches to complete. Also, each new tab running a different search will continue to run until one has finished, then once one has finished another will go. This process is ~4 seconds for each search. Seems like all searches are in a very slow queue.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So for this example book I have in the system there are 7 items that are searchable. If I go through and open each in a separate tab the total process for all of this is 30+seconds. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I tried running a webserver load test with just 10 users clicking on a different link each time the new page loaded and it failed horribly with an average page load wait of 50 seconds<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I really don’t know where to go to look for what’s causing this.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When I use the “browse by author or subject search”, the authority search results page comes back in less than 2 seconds. Though it does show 0 biblios records (no clue what that is)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve gone through many example sites found here:<o:p></o:p></p><p class=MsoNormal><a href="http://www.liblime.com/demos">http://www.liblime.com/demos</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>And they don’t seem to have this same issue. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any help. Thought, direction would be greatly appreciated!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Jeremy<o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><o:p></o:p></pre><pre><a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><o:p></o:p></pre><pre><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><o:p></o:p></pre></div></body></html>