[Koha] Performance improvement suggestions

[Furst, Kevin]

After running the tuner and making some changes to my config, I believe the
improvements are satisfactory for now.

*Kevin Furst*
Technology Director
Pine River-Backus Schools
o | 218.587.8030
@ | 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 Thu, Aug 31, 2023 at 1:11 PM Fridolin SOMERS <
fridolin.somers at biblibre.com> wrote:

> 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
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>