[Koha] Performance improvement suggestions

[Cindy Murdock Ames]

Hi Kevin,

By any chance are you using certbot to provide https encryption?  I
recently set up a new server using certbot, and Koha was incredibly slow
until I realized that the line in the ssl.conf file generated by certbot in
/etc/apache2/sites-available had the Include lines for plack in the
intranet and opac sections commented out.  So in my case plack was running
but it wasn't doing anything.  Not sure how that happened, but once I
uncommented them and restarted apache Koha got much faster.  I manually set
up certbot rather than using the option in koha-create, if that makes any
difference.

c.
-----------------------------------------------------------
Cindy Murdock Ames
IT Services Director
Meadville Public Library | CCFLS
https://meadvillelibrary.org | https://ccfls.org

Please report tech support issues in Mantis:  https://mantis.ccfls.org


On Thu, Aug 31, 2023 at 2: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
>