Hello everyone, I am new on this list, and have just begun, with a colleague, managing the KOHA installation in our library that has about 10000 books and some journals. Our OPAC had become terribly slow and on exploring we noticed that a mysqldump would result in a file of over 5GB. This large size, we realized, was due to the cleanup_database.pl script not being called. After running it for about a week with --sessdays 7 --zebraqueue --list-invites --mail --merged --import --logs --searchhistory --restrictions we have brought the mysqldump file to about 20-22 MB. While the speed of an OPAC search has improved considerably, it is still slow. For example, as suggested by a reply to a similar question, I looked at "Inspect Element > Network" and found that most queries of GET opac-detail.pl and opac-search.pl take about 9-10 seconds. Koha Version: 3.2202000 (<meta name="generator" content="Koha 3.2202000" />) running on a virtual machine (Debian 8.3). The base machine is Debian 9.0. MySQL server 5.5.47-0+deb8u1 is on the VM itself. Uses zebra. On the virtual machine # free -m gives total used free shared buffers cached Mem: 16023 2042 13981 341 174 1290 -/+ buffers/cache: 576 15446 Swap: 16383 0 16383 We plan to upgrade to Koha 17.05 soon, but wanted to understand how to speed up the search. Is moving to a stand-alone server the only solution? I am new to this, so I might not have given you all the relevant information about the problem. Please let me know if some other piece of information will help. Thank you. With regards, Manoj. -- Manoj Kummini Associate Professor, Mathematics, Chennai Mathematical Institute, Siruseri Tamilnadu 603103. India. 12 deg 50 min N, 80 deg 13 min E. http://www.cmi.ac.in/~mkummini/index.html
Hello Manoj, Koha 3.22.02 is a lot of versions behind the last 3.22.x version (3.22.21). Take a look at the value of use_zebra_facets in your koha-conf.xml file. If enabled, disable it (see bug 13665). If you are not using Plack, take a look at this wiki page https://wiki.koha-community.org/wiki/Benchmark_for_16.11 You will see the performance you will gain to use it (and memcached) on Koha versions >= 16.05 Regards, Jonathan On Thu, 3 Aug 2017 at 08:04 Manoj Kummini <mkummini@cmi.ac.in> wrote:
Hello everyone,
I am new on this list, and have just begun, with a colleague, managing the KOHA installation in our library that has about 10000 books and some journals.
Our OPAC had become terribly slow and on exploring we noticed that a mysqldump would result in a file of over 5GB. This large size, we realized, was due to the cleanup_database.pl script not being called. After running it for about a week with
--sessdays 7 --zebraqueue --list-invites --mail --merged --import --logs --searchhistory --restrictions
we have brought the mysqldump file to about 20-22 MB.
While the speed of an OPAC search has improved considerably, it is still slow. For example, as suggested by a reply to a similar question, I looked at "Inspect Element > Network" and found that most queries of GET opac-detail.pl and opac-search.pl take about 9-10 seconds.
Koha Version: 3.2202000 (<meta name="generator" content="Koha 3.2202000" />) running on a virtual machine (Debian 8.3). The base machine is Debian 9.0. MySQL server 5.5.47-0+deb8u1 is on the VM itself.
Uses zebra.
On the virtual machine # free -m gives total used free shared buffers cached Mem: 16023 2042 13981 341 174 1290 -/+ buffers/cache: 576 15446 Swap: 16383 0 16383
We plan to upgrade to Koha 17.05 soon, but wanted to understand how to speed up the search. Is moving to a stand-alone server the only solution?
I am new to this, so I might not have given you all the relevant information about the problem. Please let me know if some other piece of information will help.
Thank you.
With regards, Manoj.
-- Manoj Kummini Associate Professor, Mathematics, Chennai Mathematical Institute, Siruseri Tamilnadu 603103. India. 12 deg 50 min N, 80 deg 13 min E. http://www.cmi.ac.in/~mkummini/index.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Thank you for your reply. On Thu 03 Aug 2017 14:02:53 +0000, jonathan.druart@bugs.koha-community.org wrote:
Koha 3.22.02 is a lot of versions behind the last 3.22.x version (3.22.21).
Take a look at the value of use_zebra_facets in your koha-conf.xml file. If enabled, disable it (see bug 13665).
In /etc/koha/sites/<site_name>/koha-conf.xml it was <use_zebra_facets>1</use_zebra_facets> which I changed to <use_zebra_facets>0</use_zebra_facets> but the speed has not improved much. I have two questions: 1. I restarted apache2; is there any `restarting' of Koha that needs to be done? 2. Is it necessary to change the value in /etc/koha/koha-conf-site.xml.in also? I have not done that.
If you are not using Plack, take a look at this wiki page https://wiki.koha-community.org/wiki/Benchmark_for_16.11 You will see the performance you will gain to use it (and memcached) on Koha versions >= 16.05
Perhaps we would just move to 16.11 or 17.05 instead of trying to speed up the current OPAC. Thank you. Manoj. -- Manoj Kummini Associate Professor, Mathematics, Chennai Mathematical Institute, Siruseri Tamilnadu 603103. India. 12 deg 50 min N, 80 deg 13 min E. http://www.cmi.ac.in/~mkummini/index.html
Restart memcached and plack (if running) to take into account the changes. On Thu, 3 Aug 2017 at 21:01 Manoj Kummini <mkummini@cmi.ac.in> wrote:
Thank you for your reply.
On Thu 03 Aug 2017 14:02:53 +0000, jonathan.druart@bugs.koha-community.org wrote:
Koha 3.22.02 is a lot of versions behind the last 3.22.x version (3.22.21).
Take a look at the value of use_zebra_facets in your koha-conf.xml file. If enabled, disable it (see bug 13665).
In /etc/koha/sites/<site_name>/koha-conf.xml it was
<use_zebra_facets>1</use_zebra_facets>
which I changed to
<use_zebra_facets>0</use_zebra_facets>
but the speed has not improved much. I have two questions:
1. I restarted apache2; is there any `restarting' of Koha that needs to be done?
2. Is it necessary to change the value in /etc/koha/koha-conf-site.xml.in also? I have not done that.
If you are not using Plack, take a look at this wiki page https://wiki.koha-community.org/wiki/Benchmark_for_16.11 You will see the performance you will gain to use it (and memcached) on Koha versions >= 16.05
Perhaps we would just move to 16.11 or 17.05 instead of trying to speed up the current OPAC.
Thank you.
Manoj.
-- Manoj Kummini Associate Professor, Mathematics, Chennai Mathematical Institute, Siruseri Tamilnadu 603103. India. 12 deg 50 min N, 80 deg 13 min E. http://www.cmi.ac.in/~mkummini/index.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Jonathan Druart -
Manoj Kummini