[Koha-bugs] [Bug 34141] New: OPAC Search Performance on Ubuntu Server

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34141

            Bug ID: 34141
           Summary: OPAC Search Performance on Ubuntu Server
 Change sponsored?: ---
           Product: Koha
           Version: 22.05
          Hardware: All
                OS: Linux
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Searching
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: amar at ourlib.in
        QA Contact: testopia at bugs.koha-community.org

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

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.