Re: [Koha] Please advice how to improve our search issue
At 11:19 AM 4/10/2013 +1200, Robin Sheat wrote: Paul schreef op di 09-04-2013 om 18:27 [-0400]: That looks like a very busy, if not overloaded, server. You need (at least) to increase the size of your swap to at least double what it is currently set at (either resize partition or add a swapfile.) Not it doesn't, it looks like a very comfortably loaded server. Yeah ... maybe I went too fast, in the original email column headers were out of kilt; my apologies. However, the example I gave of the sandbox shows very different results which is why I mentioned MemCache. I'm not claiming that this is the only reason, but this list is probably not the right place to discuss other checks (e.g. cat /proc/swaps, vmstat, htop) for memory management. Best - Paul total used free sharedbuffers cached Mem: 1955 1881 73 0 15 1350 -/+ buffers/cache:514 1440 Swap: 2997 2 2995 It has 2GB RAM, 3GB swap. 514MB RAM (~25%) is in use, and 2MB swap (more or less nothing) is in use. So it's got plenty of room to breathe. The key line is the one that starts with '-/+ buffers/cache' as it's the one that's ignoring cache, which is what you want to do when looking at memory usage. Looking at one of our servers that's similarly specced and not usually too busy: total used free sharedbuffers cached Mem: 2012 1885127 0 71 1410 -/+ buffers/cache:402 1610 Swap: 2045 0 2045 it's really very close. So Zoe, your server is totally fine RAM-wise -- Robin Sheat Catalyst IT Ltd. â +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. http://NavalMarineArchive.com and http://UltraMarine.ca ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Please advice how to improve our search issue
On 8 April 2013 09:27, SRIS - Zoe Yu z...@sris.com.tw wrote: We used wired network, but search is slow as usual. Thank you. Hi! This page has some tips on how to increase the performance of Koha in general: http://wiki.koha-community.org/wiki/Performance I can't guarantee that it is 100% up to date, though. Best regards, Magnus Enger libriotech.no ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Please advice how to improve our search issue
At 06:10 PM 4/8/2013 -0700, zoe wrote: $ free -m output total used free sharedbuffers cached Mem: 1955 1881 73 0 15 1350 -/+ buffers/cache:514 1440 Swap: 2997 2 2995 That looks like a very busy, if not overloaded, server. You need (at least) to increase the size of your swap to at least double what it is currently set at (either resize partition or add a swapfile.) Here's my sandbox (odd memory size comes from proprietorial hardware, but it's close to yours) running Koha on Ubuntu, with MemCache: $ free -m total used free sharedbuffers cached Mem: 2379463 1916 0 82178 -/+ buffers/cache:202 2177 Swap: 3999 0 3999 Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Please advice how to improve our search issue
Paul schreef op di 09-04-2013 om 18:27 [-0400]: That looks like a very busy, if not overloaded, server. You need (at least) to increase the size of your swap to at least double what it is currently set at (either resize partition or add a swapfile.) Not it doesn't, it looks like a very comfortably loaded server. total used free sharedbuffers cached Mem: 1955 1881 73 0 15 1350 -/+ buffers/cache:514 1440 Swap: 2997 2 2995 It has 2GB RAM, 3GB swap. 514MB RAM (~25%) is in use, and 2MB swap (more or less nothing) is in use. So it's got plenty of room to breathe. The key line is the one that starts with '-/+ buffers/cache' as it's the one that's ignoring cache, which is what you want to do when looking at memory usage. Looking at one of our servers that's similarly specced and not usually too busy: total used free sharedbuffers cached Mem: 2012 1885127 0 71 1410 -/+ buffers/cache:402 1610 Swap: 2045 0 2045 it's really very close. So Zoe, your server is totally fine RAM-wise -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Please advice how to improve our search issue
Whats the amount of memory (RAM) of your server and processor On 2 April 2013 09:21, zoe z...@sris.com.tw wrote: hello all, Our Koha response time is too slow. We have 217062 biblio records, 289026 items, and with zebra index. When I use keyword to search, it spent almost 30s for the slowest one, the averige is 10s. Is there anyone who has ever met this situation and solved the issue? OS: Ubuntu 12.04 Koha version: 3.06.02.000 Any help. Thought, direction would be greatly appreciated! Thank you. Zoe -- View this message in context: http://koha.1045719.n5.nabble.com/Please-advice-how-to-improve-our-search-issue-tp5749360.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 SKYPE: Libsitali ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Please advice how to improve our search issue
The other thing to check for is whether the computer used for check-in and check-out is on a wired network or wireless. On my system I discovered that check-in/check-out tends to be slower or on a computer with wireless connectivity than the one on a wired network On 2 April 2013 09:21, zoe z...@sris.com.tw wrote: hello all, Our Koha response time is too slow. We have 217062 biblio records, 289026 items, and with zebra index. When I use keyword to search, it spent almost 30s for the slowest one, the averige is 10s. Is there anyone who has ever met this situation and solved the issue? OS: Ubuntu 12.04 Koha version: 3.06.02.000 Any help. Thought, direction would be greatly appreciated! Thank you. Zoe -- View this message in context: http://koha.1045719.n5.nabble.com/Please-advice-how-to-improve-our-search-issue-tp5749360.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 SKYPE: Libsitali ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Please advice how to improve our search issue
I am using ubuntu 12.04 and koha 3.8.7. I have about 1000-2000 books. My search about 2s. your problem is, maybe, large database, next ram is low (check it with free -m), then check %cpu is working! Make sure zebra is working ps aux | grep zebrasrv and is enabled in Koha! Best regards! Nguyen Quoc Uy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Please advice how to improve our search issue
We used wired network, but search is slow as usual. Thank you. 2013/4/8 Chrispin Simasiku Sitali libsit...@gmail.com The other thing to check for is whether the computer used for check-in and check-out is on a wired network or wireless. On my system I discovered that check-in/check-out tends to be slower or on a computer with wireless connectivity than the one on a wired network On 2 April 2013 09:21, zoe z...@sris.com.tw wrote: hello all, Our Koha response time is too slow. We have 217062 biblio records, 289026 items, and with zebra index. When I use keyword to search, it spent almost 30s for the slowest one, the averige is 10s. Is there anyone who has ever met this situation and solved the issue? OS: Ubuntu 12.04 Koha version: 3.06.02.000 Any help. Thought, direction would be greatly appreciated! Thank you. Zoe -- View this message in context: http://koha.1045719.n5.nabble.com/Please-advice-how-to-improve-our-search-issue-tp5749360.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 SKYPE: Libsitali -- Zoe Yu Shou Ray Information Service Co., Ltd. 10F, No. 166, Jianyi Rd., Zhonghe District, New Taipei City 23511, Taiwan, R.O.C. TEL : 02-8226-8587#1010 E-mail : z...@sris.com.tw ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Please advice how to improve our search issue
hello all, Our Koha response time is too slow. We have 217062 biblio records, 289026 items, and with zebra index. When I use keyword to search, it spent almost 30s for the slowest one, the averige is 10s. Is there anyone who has ever met this situation and solved the issue? OS: Ubuntu 12.04 Koha version: 3.06.02.000 Any help. Thought, direction would be greatly appreciated! Thank you. Zoe -- View this message in context: http://koha.1045719.n5.nabble.com/Please-advice-how-to-improve-our-search-issue-tp5749360.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
