Hi, I have noticed some slow opac/intranet searching on sites and I can't seem to pinpoint the problem. The "opac-search.pl", takes between 5500ms and 7500ms for any search term - the hit count can be 10 or 16000, the search time is comparable. Running the same search, directly via the yaz-client, returns the hit count (and record dump) almost instantly. The sites are plack enabled, running Koha 3.22.06 and memcache is also configured. The zebra-out.log shows lines similar to below (which appear to be innocuous): 15:38:02-16/05 zebrasrv(1) [warn] ir_session (exception) 15:47:14-16/05 zebrasrv(2) [warn] ir_session (exception) 15:57:15-16/05 zebrasrv(3) [warn] ir_session (exception) 16:03:22-16/05 zebrasrv(4) [warn] ir_session (exception) 16:04:15-16/05 zebrasrv(5) [warn] ir_session (exception) The only other log of interest is the opac-error.log but this just displays some equally innocuous errors. On one system there are just under 100k biblios. It is a relatively small system but just to be certain I spun up a test box and assigned it 16GB RAM and 8 CPUs, SSDs for storage. I left the sysprefs as vanilla. I noticed no difference in the response time(s). The majority of sites are running Jessie. I have netdata running on the boxes and there is never any load on any resource - no slow MySQL queries either. I also tested some of the demo Koha sites, from the community site, and while they're are not as slow, they certainly appear to be slow(ish). Would anyone have any ideas on what I might have overlooked? Could this just be a perception issue (although most of the clients have raised issues). Thanks Regards Barry Cannon Interleaf Technology http://www.interleaf.ie Tel: +35312865855 Email: bc@interleaf.ie Skype: bar.cannon
Barry, The zebrasrv(1) [warn] ir_session (exception) is unrelated to your performance issues. The yaz-client search cannot be compared with the interface. Koha 3.22.06 is much slower than say Koha 3.16. You really need plack and memcached. Check if they function properly. 16GB RAM and SSD sounds good to me. Marcel -----Oorspronkelijk bericht----- Van: koha-devel-bounces@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] Namens Barry Cannon Verzonden: maandag 23 mei 2016 12:36 Aan: , <koha-devel@lists.koha-community.org> Onderwerp: [Koha-devel] Slow Searching Hi, I have noticed some slow opac/intranet searching on sites and I can't seem to pinpoint the problem. The "opac-search.pl", takes between 5500ms and 7500ms for any search term - the hit count can be 10 or 16000, the search time is comparable. Running the same search, directly via the yaz-client, returns the hit count (and record dump) almost instantly. The sites are plack enabled, running Koha 3.22.06 and memcache is also configured. The zebra-out.log shows lines similar to below (which appear to be innocuous): 15:38:02-16/05 zebrasrv(1) [warn] ir_session (exception) 15:47:14-16/05 zebrasrv(2) [warn] ir_session (exception) 15:57:15-16/05 zebrasrv(3) [warn] ir_session (exception) 16:03:22-16/05 zebrasrv(4) [warn] ir_session (exception) 16:04:15-16/05 zebrasrv(5) [warn] ir_session (exception) The only other log of interest is the opac-error.log but this just displays some equally innocuous errors. On one system there are just under 100k biblios. It is a relatively small system but just to be certain I spun up a test box and assigned it 16GB RAM and 8 CPUs, SSDs for storage. I left the sysprefs as vanilla. I noticed no difference in the response time(s). The majority of sites are running Jessie. I have netdata running on the boxes and there is never any load on any resource - no slow MySQL queries either. I also tested some of the demo Koha sites, from the community site, and while they're are not as slow, they certainly appear to be slow(ish). Would anyone have any ideas on what I might have overlooked? Could this just be a perception issue (although most of the clients have raised issues). Thanks Regards Barry Cannon Interleaf Technology http://www.interleaf.ie Tel: +35312865855 Email: bc@interleaf.ie Skype: bar.cannon _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
Thanks Marcel, Plack and memcache are configured correctly though. Maybe it is just the version differences. Thanks Regards Barry Cannon Interleaf Technology http://www.interleaf.ie Tel: +35312865855 Email: bc@interleaf.ie Skype: bar.cannon ________________________________________ From: koha-devel-bounces@lists.koha-community.org [koha-devel-bounces@lists.koha-community.org] on behalf of Marcel de Rooy [M.de.Rooy@rijksmuseum.nl] Sent: 23 May 2016 11:41 To: , Subject: Re: [Koha-devel] Slow Searching Barry, The zebrasrv(1) [warn] ir_session (exception) is unrelated to your performance issues. The yaz-client search cannot be compared with the interface. Koha 3.22.06 is much slower than say Koha 3.16. You really need plack and memcached. Check if they function properly. 16GB RAM and SSD sounds good to me. Marcel -----Oorspronkelijk bericht----- Van: koha-devel-bounces@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] Namens Barry Cannon Verzonden: maandag 23 mei 2016 12:36 Aan: , <koha-devel@lists.koha-community.org> Onderwerp: [Koha-devel] Slow Searching Hi, I have noticed some slow opac/intranet searching on sites and I can't seem to pinpoint the problem. The "opac-search.pl", takes between 5500ms and 7500ms for any search term - the hit count can be 10 or 16000, the search time is comparable. Running the same search, directly via the yaz-client, returns the hit count (and record dump) almost instantly. The sites are plack enabled, running Koha 3.22.06 and memcache is also configured. The zebra-out.log shows lines similar to below (which appear to be innocuous): 15:38:02-16/05 zebrasrv(1) [warn] ir_session (exception) 15:47:14-16/05 zebrasrv(2) [warn] ir_session (exception) 15:57:15-16/05 zebrasrv(3) [warn] ir_session (exception) 16:03:22-16/05 zebrasrv(4) [warn] ir_session (exception) 16:04:15-16/05 zebrasrv(5) [warn] ir_session (exception) The only other log of interest is the opac-error.log but this just displays some equally innocuous errors. On one system there are just under 100k biblios. It is a relatively small system but just to be certain I spun up a test box and assigned it 16GB RAM and 8 CPUs, SSDs for storage. I left the sysprefs as vanilla. I noticed no difference in the response time(s). The majority of sites are running Jessie. I have netdata running on the boxes and there is never any load on any resource - no slow MySQL queries either. I also tested some of the demo Koha sites, from the community site, and while they're are not as slow, they certainly appear to be slow(ish). Would anyone have any ideas on what I might have overlooked? Could this just be a perception issue (although most of the clients have raised issues). Thanks Regards Barry Cannon Interleaf Technology http://www.interleaf.ie Tel: +35312865855 Email: bc@interleaf.ie Skype: bar.cannon _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
Hi Barry, Have a look at bug 15342 and all related. Bug 16041 is in 3.22.7 and could help for search results. Bug 15263 as well. Regards, Jonathan 2016-05-23 11:36 GMT+01:00 Barry Cannon <bar@interleaf.ie>:
Hi, I have noticed some slow opac/intranet searching on sites and I can't seem to pinpoint the problem. The "opac-search.pl", takes between 5500ms and 7500ms for any search term - the hit count can be 10 or 16000, the search time is comparable. Running the same search, directly via the yaz-client, returns the hit count (and record dump) almost instantly.
The sites are plack enabled, running Koha 3.22.06 and memcache is also configured. The zebra-out.log shows lines similar to below (which appear to be innocuous):
15:38:02-16/05 zebrasrv(1) [warn] ir_session (exception) 15:47:14-16/05 zebrasrv(2) [warn] ir_session (exception) 15:57:15-16/05 zebrasrv(3) [warn] ir_session (exception) 16:03:22-16/05 zebrasrv(4) [warn] ir_session (exception) 16:04:15-16/05 zebrasrv(5) [warn] ir_session (exception)
The only other log of interest is the opac-error.log but this just displays some equally innocuous errors.
On one system there are just under 100k biblios. It is a relatively small system but just to be certain I spun up a test box and assigned it 16GB RAM and 8 CPUs, SSDs for storage. I left the sysprefs as vanilla. I noticed no difference in the response time(s). The majority of sites are running Jessie. I have netdata running on the boxes and there is never any load on any resource - no slow MySQL queries either.
I also tested some of the demo Koha sites, from the community site, and while they're are not as slow, they certainly appear to be slow(ish).
Would anyone have any ideas on what I might have overlooked? Could this just be a perception issue (although most of the clients have raised issues).
Thanks
Regards Barry Cannon Interleaf Technology http://www.interleaf.ie Tel: +35312865855 Email: bc@interleaf.ie Skype: bar.cannon
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
participants (3)
-
Barry Cannon -
Jonathan Druart -
Marcel de Rooy