[Koha] [EXTERNAL] Re: Reports timing out, prevents access to web interfaces
Bales (US), Tasha R
tasha.r.bales at boeing.com
Tue Oct 12 14:46:01 NZDT 2021
Thanks for your reply, Chris. One of our team members posited that there might be an issue---or something we can tweak--to decrease the priority of Reports/MySQL, so that it isn’t sucking the life out of the rest of the application. We’ll keep investigating.
Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/
From: Chris Brown [mailto:chris at stayawake.co.uk]
Sent: Wednesday, October 6, 2021 23:40
To: Bales (US), Tasha R <tasha.r.bales at boeing.com>; koha <koha at lists.katipo.co.nz>
Subject: [EXTERNAL] Re: [Koha] Reports timing out, prevents access to web interfaces
Importance: High
EXT email: be mindful of links/attachments.
Hi Tasha,
Since I'm guessing you have access to a Linux command prompt on your server, you could try running "top". It would at least confirm if the CPU is saturated, and which processes are consuming all the CPU.
Best Regards,
Chris Brown
On Wed, Oct 6, 2021 at 10:32 PM Bales (US), Tasha R <tasha.r.bales at boeing.com<mailto:tasha.r.bales at boeing.com>> wrote:
Good afternoon,
I'm experiencing an issue where if I'm working in the staff interface and kick off a long-running Report, I'm unable to navigate to or use Koha in any other browser tab, or in any other browser, either in the staff or public interface. I've confirmed that this affects other users working on their own machines too; in other words, my report interrupts their access.
I doubt that this is intended behavior. I'm going to try to do some query-tuning (any suggestions for tools to use to optimize/identify inefficient queries?).
Any other ideas to troubleshoot this issue? I found an old list post that suggested the Koha Tuning Guide<https://wiki.koha-community.org/wiki/Koha_Tuning_Guide> on the Koha Wiki, but it isn't entirely clear to me if it is comprehensive, or if all parts are relevant to our issue. I'm hesitant to blindly start changing values. Before we pursue the tuning, are there any other suggestions? Is this really a problem that is expected to happen?
I should add that long queries that need to be run on a routine basis, we'd run via cronjob. However, I'm worried that staff who work solely on the web might inadvertently run a big one-off report (or do a huge record load, also a problem), and bring down the whole system.
FWIW, we have two processors: Intel(R) Xeon(R) Silver 4110 CPU @ 2.10GHz. We have about 1.3 million records and the same number of items. We're using MySQL 5.7, and Koha 20.11.06.
Regarding RAM, this is the output of the "free" command, if relevant:
total used free shared buff/cache available
Mem: 65308616 2038820 41354324 107800 21915472 62437176
Swap: 8257532 780 8256752
Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/
_______________________________________________
Koha mailing list http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha
mailing list