Bug 34141 - OPAC Search Performance on Ubuntu Server
Summary: OPAC Search Performance on Ubuntu Server
Status: RESOLVED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: 22.05
Hardware: All Linux
: P1 - high enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-28 10:24 UTC by Developer Inside
Modified: 2023-07-10 10:11 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Developer Inside 2023-06-28 10:24:28 UTC
We are experiencing a performance issue with the OPAC search functionality on our server. Despite enabling memcached and Apache2 cache services, the OPAC search is extremely slow and consumes excessive CPU resources, leading to server downtime.

Here are the details of our server:

- Operating System: Ubuntu 20.04 LTS
- CPU: 4 cores
- RAM: 8GB
- Storage: 200GB SSD

When monitoring the server using the 'top' command, we observe that only a few OPAC search requests are being processed. However, these requests are utilizing nearly all of the available CPU resources, leaving no CPU capacity for other tasks and causing the server to go down.

It's worth mentioning that we did not utilize the 'koha-common' command for the Koha installation and setup. Instead, we downloaded the Koha tar file and performed the installation using the 'perl Makefile.PL' command.

We kindly request your assistance in improving the speed and performance of our server. Any suggestions or guidance on optimizing the OPAC search functionality would be greatly appreciated. Thank you in advance for your support.

Please check detailed server log here : https://github.com/Londheamar/koha-issue
Comment 1 Katrin Fischer 2023-07-10 10:11:40 UTC
Hi,

This sounds like a support request rather than a bug.

Questions about Koha should be asked on the Koha mailing list (http://koha-community.org/support/koha-mailing-lists/) or in the #koha IRC channel (http://koha-community.org/get-involved/irc/).

Hopefully you've already seen the Koha documentation: http://koha-community.org/documentation/

You can also find options for paid support here: https://koha-community.org/support/