[Koha] Performance improvement suggestions

[Fridolin SOMERS]

Please answer to the mailling list instead of me directly.

Le 31/08/2023 à 03:11, Furst, Kevin a écrit :
> 1. Plack is enabled and running
> 2. Haven't run db tuner you suggested yet. Will look at it today.
> 3. Hardware is Intel Xeon E5520 8GB RAM  and (8) 2TB SSDs in a RAID.
> 
> 
> *Kevin Furst*
> Technology Director
> Pine River-Backus Schools
> o | 218.587.8030
> @ | kfurst at prbschools.org <mailto:kfurst at prbschools.org>
> 
> Technology Office/Help Desk:  218-587-8510
> 
> /Confidentiality Notice: This E-mail message, including any attachments, 
> is for the sole use of the intended recipient(s) and may contain 
> confidential and privileged information. Any unauthorized review, use, 
> disclosure or distribution is prohibited. If you are not the intended 
> recipient, please contact the sender by reply E-mail and destroy all 
> copies of the original message./
> 
> 
> On Wed, Aug 30, 2023 at 8:19 PM Fridolin SOMERS 
> <fridolin.somers at biblibre.com <mailto:fridolin.somers at biblibre.com>> wrote:
> 
>     Hi,
> 
>     Did you tune DB server ? Like with mysqltuner.pl <http://mysqltuner.pl>
> 
>     Did you enable Plack mode ?
>     https://wiki.koha-community.org/wiki/Koha_on_Debian#Setup_plack
>     <https://wiki.koha-community.org/wiki/Koha_on_Debian#Setup_plack>
> 
>     Please give more informations on hardware.
> 
>     Best regards,
> 
>     Le 30/08/2023 à 09:54, Furst, Kevin a écrit :
>      > Hi,
>      >
>      > I'm running v.23.05.x on Ubuntu 20.04. I've currently got zebra
>     running for
>      > the search engine. It works correctly but is really slow. We're
>     talking ~10
>      > seconds for a return on catalog search query and maybe 5-6
>     seconds on a
>      > patron search in the staff side. Our library only has ~1000
>     patrons and 20k
>      > titles.
>      >
>      > I'm wondering if anyone has any performance enhancement
>     recommendations on
>      > the server-side that they've had success with that would help
>     speed up
>      > those times.
>      >
>      > *Kevin Furst*
>      > Technology Director
>      > Pine River-Backus Schools
>      > o | 218.587.8030
>      > @ | kfurst at prbschools.org <mailto:kfurst at prbschools.org>
>      >
>      > Technology Office/Help Desk:  218-587-8510
>      >
>      > *Confidentiality Notice: This E-mail message, including any
>     attachments, is
>      > for the sole use of the intended recipient(s) and may contain
>     confidential
>      > and privileged information. Any unauthorized review, use,
>     disclosure or
>      > distribution is prohibited. If you are not the intended
>     recipient, please
>      > contact the sender by reply E-mail and destroy all copies of the
>     original
>      > message.*
>      > _______________________________________________
>      >
>      > Koha mailing list http://koha-community.org
>     <http://koha-community.org>
>      > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>      > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
> 
>     -- 
>     Fridolin SOMERS <fridolin.somers at biblibre.com
>     <mailto:fridolin.somers at biblibre.com>>
>     Software and system maintainer 🦄
>     BibLibre, France
>     _______________________________________________
> 
>     Koha mailing list http://koha-community.org <http://koha-community.org>
>     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
> 

-- 
Fridolin SOMERS <fridolin.somers at biblibre.com>
Software and system maintainer 🦄
BibLibre, France