Re: [Koha] Performance improvement suggestions
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@prbschools.org <mailto:kfurst@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@biblibre.com <mailto:fridolin.somers@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@prbschools.org <mailto:kfurst@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@lists.katipo.co.nz <mailto:Koha@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@biblibre.com <mailto:fridolin.somers@biblibre.com>> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org <http://koha-community.org> Koha@lists.katipo.co.nz <mailto:Koha@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@biblibre.com> Software and system maintainer 🦄 BibLibre, France
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@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@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@prbschools.org <mailto:kfurst@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@biblibre.com <mailto:fridolin.somers@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@prbschools.org <mailto:kfurst@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@lists.katipo.co.nz <mailto:Koha@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@biblibre.com <mailto:fridolin.somers@biblibre.com>> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org < http://koha-community.org> Koha@lists.katipo.co.nz <mailto:Koha@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@biblibre.com> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@prbschools.org <mailto:kfurst@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@biblibre.com <mailto:fridolin.somers@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@prbschools.org <mailto:kfurst@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@lists.katipo.co.nz <mailto:Koha@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@biblibre.com <mailto:fridolin.somers@biblibre.com>> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org < http://koha-community.org> Koha@lists.katipo.co.nz <mailto:Koha@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@biblibre.com> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Cindy Murdock Ames -
Fridolin SOMERS -
Furst, Kevin