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-is... Sent from the Koha-general mailing list archive at Nabble.com.
Whats the amount of memory (RAM) of your server and processor On 2 April 2013 09:21, zoe <zoe@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-is... 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
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 <zoe@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-is... 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
We used wired network, but search is slow as usual. Thank you. 2013/4/8 Chrispin Simasiku Sitali <libsitali@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 <zoe@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-is... 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 : zoe@sris.com.tw
On 8 April 2013 09:27, SRIS - Zoe Yu <zoe@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
Greetings, How much memory (RAM) does your system have? My first gut feeling is that your machine runs out of physical memory and so it begins to use swap space. Hard drive access is much slower compared to RAM. You can determine if this idea is valid by typing at a command line: $ free -m And then post the output. GPML, Mark Tompsett
Hello Mark, $ free -m output total used free shared buffers cached Mem: 1955 1881 73 0 15 1350 -/+ buffers/cache: 514 1440 Swap: 2997 2 2995 Best Regards, Zoe -- View this message in context: http://koha.1045719.n5.nabble.com/Please-advice-how-to-improve-our-search-is... Sent from the Koha-general mailing list archive at Nabble.com.
At 06:10 PM 4/8/2013 -0700, zoe wrote:
$ free -m output
total used free shared buffers 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 shared buffers cached Mem: 2379 463 1916 0 82 178 -/+ buffers/cache: 202 2177 Swap: 3999 0 3999 Best - Paul
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 shared buffers 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 shared buffers cached Mem: 2012 1885 127 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
participants (7)
-
Chrispin Simasiku Sitali -
Magnus Enger -
Mark Tompsett -
Paul -
Robin Sheat -
SRIS - Zoe Yu -
zoe