<div dir="ltr">Zebra tends to be I/O bound -- we've seen it write enormous .zrs files to disk (~16G/query on large libraries). Bug 13665 mentions that searches could be taking upwards of 40 seconds to complete -- I think that we've seen searches time out and return no results at about 1 minute.<div><br></div><div>Is it possible to tune Zebra's space/time optimizations in any way so that it doesn't write such large files to disk?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 23, 2016 at 5:38 AM, Jonathan Druart <span dir="ltr"><<a href="mailto:jonathan.druart@bugs.koha-community.org" target="_blank">jonathan.druart@bugs.koha-community.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">See bug 13665 - Retrieve facets from zebra is slow<br>
To understand why and when use_zebra_facet=1 is slow<br>
<div class="HOEnZb"><div class="h5"><br>
2016-08-22 21:31 GMT+01:00 Barton Chittenden <<a href="mailto:barton@bywatersolutions.com">barton@bywatersolutions.com</a>>:<br>
> I haven't run into the issue with the dashes in idzebra-2.0 2.0.59, but I<br>
> have run into this, when using ICU-Chains:<br>
><br>
> Bug 16581 : ICU tokenization bug in idzebra-2.0 2.0.59-1<br>
> URL : <a href="https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16581" rel="noreferrer" target="_blank">https://bugs.koha-community.<wbr>org/bugzilla3/show_bug.cgi?id=<wbr>16581</a><br>
> Priority : P5 - low<br>
> Urgency : enhancement<br>
> Status : NEW<br>
><br>
> I also know that when use_zebra_facets was first introduced, it was *very*<br>
> slow -- I can't find any bugs about that though. It's possible that it got<br>
> so slow under idzebra-2.0 2.61 that the searches are timing out.<br>
><br>
> It should be possible to set the logging for zebra so that you can see the<br>
> PQF queries:<br>
><br>
> See<br>
><br>
> Bug 15714 : Remove zebra.log from debian scripts and add optional log levels<br>
> URL : <a href="https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15714" rel="noreferrer" target="_blank">https://bugs.koha-community.<wbr>org/bugzilla3/show_bug.cgi?id=<wbr>15714</a><br>
> Priority : P5 - low<br>
> Urgency : enhancement<br>
> Status : RESOLVED<br>
><br>
> For setting the log levels<br>
><br>
> And <a href="http://koha.1045719.n5.nabble.com/Improving-Zebra-logging-td5861827.html" rel="noreferrer" target="_blank">http://koha.1045719.n5.nabble.<wbr>com/Improving-Zebra-logging-<wbr>td5861827.html</a><br>
><br>
> For a general discussion of how to use them.<br>
><br>
> ... This should give you some idea of what's failing, both in terms of the<br>
> dashes in 2.0.59 and the non-functional zebra facets under 2.0.61.<br>
><br>
> My general feeling is that 2.0.59 is irredeemably broken by bug 16581, and<br>
> we need at least 2.0.60, but I don't have any experience with zebra facets.<br>
><br>
> --Barton<br>
><br>
><br>
><br>
> On Mon, Aug 22, 2016 at 2:49 PM, Mark Tompsett <<a href="mailto:mtompset@hotmail.com">mtompset@hotmail.com</a>> wrote:<br>
>><br>
>> Greetings,<br>
>><br>
>> Similar problem. I hope someone has a better solution than setting it to<br>
>> 0.<br>
>><br>
>> GPML,<br>
>> Mark Tompsett<br>
>><br>
>> -----Original Message-----<br>
>> From: Philippe Blouin<br>
>> Sent: Monday, August 22, 2016 2:40 PM<br>
>> To: <a href="mailto:koha-devel@lists.koha-community.org">koha-devel@lists.koha-<wbr>community.org</a><br>
>> Subject: [Koha-devel] 16.05, zebra and jessie<br>
>><br>
>> Hello!<br>
>><br>
>> We're trying to find the correction combination. We're new on Jessie,<br>
>> so we still have some tweaking needed...<br>
>><br>
>> - By default, we get zebra 2.00.59 installed on Jessie through the<br>
>> packages.<br>
>> - On 16.05, we get some very bad results in the search when the itemtype<br>
>> contains an hyphen (-), like 'A-DOC'.<br>
>> - So we installed zebra 2.00.62. This fixes the search...<br>
>> - But now we do not have facets.<br>
>> - So we set <use_zebra_facets>0</use_<wbr>zebra_facets><br>
>> - And now we have facets. But this feels... wrong?<br>
>><br>
>> My dummy question: what is the supposedly correct version of Zebra on<br>
>> Jessie ?<br>
>> And we're we correct in setting the config to 0 ?<br>
>><br>
>> Thanks<br>
>> Blou<br>
>> ______________________________<wbr>_________________<br>
>> Koha-devel mailing list<br>
>> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-<wbr>community.org</a><br>
>> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.<wbr>org/cgi-bin/mailman/listinfo/<wbr>koha-devel</a><br>
>> website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
>> git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
>> bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.<wbr>org/</a><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> Koha-devel mailing list<br>
>> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-<wbr>community.org</a><br>
>> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.<wbr>org/cgi-bin/mailman/listinfo/<wbr>koha-devel</a><br>
>> website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
>> git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
>> bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.<wbr>org/</a><br>
><br>
><br>
><br>
> ______________________________<wbr>_________________<br>
> Koha-devel mailing list<br>
> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-<wbr>community.org</a><br>
> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.<wbr>org/cgi-bin/mailman/listinfo/<wbr>koha-devel</a><br>
> website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
> git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
> bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.<wbr>org/</a><br>
</div></div></blockquote></div><br></div>