[Koha] High CPU usage, slow OPAC/Staff interface, with memcache

[Hector Gonzalez Jaime]

Daniel, if you use plack, check your access logs with:

sudo tail -f /var/log/koha/YOURKOHASITE/plack.log

or

sudo grep opac-search /var/log/koha/YOURSITE/plack.log | more

search the list archives, there was a discussion a few weeks back about 
this, and ways to use fail2ban to help with bots that fail to care about 
robots.txt


On 8/16/24 15:09, Daniel Owens wrote:
> Thank you for responding, Alvaro.
>
> I hadn't recently checked apache logs. I had been checking the apache 
> error logs to see why apache was shutting down. But that seems to have 
> been resolved with memcache.
>
> But the CPU issue remains. I am guessing you mean the access log? I 
> don't see much there. But maybe I am looking in the wrong place: sudo 
> tail -f /var/log/apache2/access.log
>
> If I find the right place, am I looking for a single IP that is 
> accessing Koha repeatedly?
>
> Daniel
>
> On 8/15/24 3:48 PM, Alvaro Cornejo wrote:
>> Hi Daniel
>>
>> Have you checked apache logs? It may be a crawl robot that is 
>> indexing your system
>>
>> Regards,
>>
>> Alvaro
>>
>>
>> |----------------------------------------------------------------------------------------| 
>>
>> Stay safe / Cuídate/ Reste sécurisé
>> */7/*Switch off as you go / Apaga lo que no usas / Débranchez au fur 
>> et à mesure.
>> *q *Recycle always / Recicla siempre / Recyclez toujours
>> PPrint only if absolutely necessary / Imprime solo si es necesario / 
>> Imprimez seulement si nécessaire
>>
>>
>> Le jeu. 15 août 2024 à 15:27, Daniel Owens <dcowens76 at gmail.com> a 
>> écrit :
>>
>>     I am running Koha 24.05.03.000 on Ubuntu 24.04 with 8 vCPU cores
>>     and 32
>>     GB of RAM.
>>
>>     Recently I found that the VPS was running at 100% CPU usage and
>>     discovered that memcache was not running. The high CPU usage would
>>     cause
>>     it to crash. To solve this, I started memcache and confirmed it was
>>     running and followed the instructions at
>> https://wiki.koha-community.org/wiki/Koha_Tuning_Guide. It seemed
>>     to run
>>     better for a short time. But it is back up to 100% usage, which
>>     slows it
>>     down considerably. When I run top to see what is using the CPU, it
>>     shows
>>     many opac-search.pl <http://opac-search.pl> running on many
>>     processes. Is that normal? Are there
>>     other things I can do to reign in CPU usage?
>>
>>     Daniel
>>
>>     _______________________________________________
>>
>>     Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
>>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
>
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Hector Gonzalez
cacho at genac.org