[Koha] Koha getting slow

[Alvaro Cornejo]

Hi Ikbar

It looks like there is something delaying/slowing opac search queries.

As you can see, CPU usage is really high 61 & 56 as well as cumulative CPU
time for those queries processes.

kplh-ko+  8972   942 *61 *11:53 ?       * 00:01:02*
 /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
kplh-ko+  8977   942 *56* 11:53 ?        *00:00:54*
 /usr/share/koha/opac/cgi-bin/opac/opac-search.pl

Have you modified indexes? Maybe a full DB reindex will fix your issue.

Regards,

Alvaro

|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
              Visitenos en www.perusms.com


Le mar. 16 juil. 2019 à 23:48, ikbar <plhutem.koha at gmail.com> a écrit :

> sorry
>
> here i paste the result
>
> root at plh:~# ps -ef | grep koha

kplh-ko+   818     1  0 10:53 ?        00:00:00
> daemon --name=kplh-koha-zebra
> --pidfiles=/var/run/koha/kplh/ --errlog=kplh-koha.kplh-koha --
> /usr/bin/zebrasrv -v none,fatal,warn -k 1024 -f
> /etc/koha/sites/kplh/koha-conf.xml
> kplh-ko+   822   818  0 10:53 ?        00:00:03 /usr/bin/zebrasrv
> -v none,fatal,warn -k 1024 -f /etc/koha/sites/kplh/
> kplh-ko+   942     1  0 10:53 ?        00:00:01 starman master -M
> FindBin --max-requests 50 --workers 2
> --user=kplh-kog /var/log/koha/kplh/plack-error.log -E deployment
> --socket /var/run/koha/kplh/plack.sock /etc/koha/plack.psgi
> kplh-ko+   972     1  0 10:53 ?        00:00:00
> daemon --name=kplh-koha-indexer
> --errlog=/var/log/koha/kplh/indexer-e/kplh/ --verbose=1 --respawn
> --delay=30 --user=kplh-koha.kplh-koha
> --/usr/share/koha/bin/migration_tools/rebuild_zeb
> kplh-ko+   973   972  0 10:53 ?        00:00:07
> /usr/bin/perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -d
> kplh-ko+  8972   942 61 11:53 ?
> 00:01:02 /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
> kplh-ko+  8977   942 56 11:53 ?
> 00:00:54 /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
> kplh-ko+  9125   822  0 11:55 ?        00:00:00 /usr/bin/zebrasrv
> -v none,fatal,warn -k 1024 -f /etc/koha/sites/kplh/
> kplh-ko+  9126   822  0 11:55 ?        00:00:00 /usr/bin/zebrasrv
> -v none,fatal,warn -k 1024 -f /etc/koha/sites/kplh/
> root      9128  9019  0 11:55 pts/1    00:00:00 grep koha
>
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>