hi all masters im here faced some issue when my koha installed 4 months ago getting slower. Im tried clear memchached, restart apache and restart plack, but the performance still slow even when i go to intra login page its slow, after login page to intra page also slow and clicking to each module in koha same performance...its too SLOW. not like before. Here some details about my koha : Server information Koha version: 18.05.10.000 OS version ('uname -a'): Linux kohaweb 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.024001 Perl @INC: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base /var/lib/koha/kplh/plugins /var/lib/koha/kplh/plugins MySQL version: mysql Ver 15.1 Distrib 10.1.37-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Apache version: Server version: Apache/2.4.25 (Debian) PSGI: Plack (deployment) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_kplh | Status: running. | Config read from: koha-conf.xml Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU Date and time: 03/07/2019 04:08 AM Time zone: Used: Asia/Kuala_Lumpur | Config: Undefined | Environment (TZ): Undefined And my server requirement is running in VM where RAM is 32GB, 16vCPUs Im stuck.... please help me to solve this issue.... thanks for advance -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Ikbar Have you run top/mysqltop? Those commands might give you an idea where to start looking for. 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 mer. 3 juil. 2019 à 03:16, ikbar <plhutem.koha@gmail.com> a écrit :
hi all masters
im here faced some issue when my koha installed 4 months ago getting slower. Im tried clear memchached, restart apache and restart plack, but the performance still slow even when i go to intra login page its slow, after login page to intra page also slow and clicking to each module in koha same performance...its too SLOW. not like before. Here some details about my koha :
Server information Koha version: 18.05.10.000 OS version ('uname -a'): Linux kohaweb 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.024001 Perl @INC: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base /var/lib/koha/kplh/plugins /var/lib/koha/kplh/plugins MySQL version: mysql Ver 15.1 Distrib 10.1.37-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Apache version: Server version: Apache/2.4.25 (Debian) PSGI: Plack (deployment) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_kplh | Status: running. | Config read from: koha-conf.xml Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU Date and time: 03/07/2019 04:08 AM Time zone: Used: Asia/Kuala_Lumpur | Config: Undefined | Environment (TZ): Undefined
And my server requirement is running in VM where RAM is 32GB, 16vCPUs Im stuck.... please help me to solve this issue.... thanks for advance
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
hi alvaro im not IT person.... but im asking help from you. what is run top/mysqltop. Please help me tq -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Ikbar They are a couple of commands that you can run on your server to check its resources usage.
From the command line, just type "top" and you will get a display of your machine resources usage (memory/cpu/disk/processes/etc)
You can use "mtop" or "mytop" to check mysql specific usage information. Those commands might not be installed by default on your machine, so you might use your OS installer first 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 mer. 3 juil. 2019 à 23:39, ikbar <plhutem.koha@gmail.com> a écrit :
hi alvaro
im not IT person.... but im asking help from you. what is run top/mysqltop. Please help me
tq
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
hi alvaro bro here i attached my server top <http://koha.1045719.n5.nabble.com/file/t341327/KohaProdTopCommand.png> what can you see bro??? tq -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Ikbar Look like you are running two instances of koha and they are using a lot of CPU time??? try "ps -ef | grep koha" to see how many and which koha proceses are running Regards You can also try to restart koha with service koha-comon restart 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 ven. 5 juil. 2019 à 01:05, ikbar <plhutem.koha@gmail.com> a écrit :
hi alvaro bro
here i attached my server top <http://koha.1045719.n5.nabble.com/file/t341327/KohaProdTopCommand.png>
what can you see bro???
tq
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Alvaro Sorry for the late reply.....here I do as you said: "ps -ef | grep koha" ... please help me.... koha getting worst right now.... now everyday i got to reboot the server early morning and cause anger from service staff.. please do help me..tq </file/t341327/KohaPS_EFGrepKoha.png> -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
still you can't attach screenshots like that. Either copy the messages as text or upload the screenshot somewhere and add an url here. all the best Am 17.07.19 um 06:02 schrieb ikbar:
Hi Alvaro
Sorry for the late reply.....here I do as you said: "ps -ef | grep koha" ... please help me.... koha getting worst right now.... now everyday i got to reboot the server early morning and cause anger from service staff.. please do help me..tq
</file/t341327/KohaPS_EFGrepKoha.png>
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
sorry here i paste the result root@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
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@gmail.com> a écrit :
sorry
here i paste the result
root@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Try fail2ban to block some bots. Check the access logs, I bet there are some bots messing with your server. El mié., 17 de julio de 2019 01:48, ikbar <plhutem.koha@gmail.com> escribió:
sorry
here i paste the result
root@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Alvaro Cornejo -
Franz Dietrich -
ikbar -
Tomas Cohen Arazi