In production I am not aware of something you could do (well there is strace if you are patient and quick :D) In test you could use a code profiler or tell mysql to log slow queries. But the code profiler will be hazardous if it does not happens 100% of the time and htop would have told you if mysql was the culprit.
On Mon, 17 Apr 2017 at 17:43 Michael Kuhn <[email protected]> wrote: > Hi Jonathan > > Some patrons have no issues/holds at all, some have very few (2 or 3), > some have some more. As I wrote the slow login process doesn't happen > all the time, but more or less often. At the moment we can't see a > pattern why it happens, but it does happen... > > Is there maybe a way how to debug "opac-user.pl" so we could find out > what the script is actually doing during the slow login process? > > Regards, Michael > > > Am 17.04.2017 um 14:37 schrieb Jonathan Druart: > > Hello Michael, > > > > How many issues and holds has the patron? > > > > Regards, > > Jonathan > > > > On Thu, 13 Apr 2017 at 15:13 Michael Kuhn <[email protected]> wrote: > > > >> Hi > >> > >> We're running a new host with Debian GNU/Linux 8 and Koha 16.11.04. > >> > >> Usually the Koha OPAC login process is quick as expected. But sometimes > >> when trying to login it takes 10 to 40 seconds until the login process > >> finally comes to an end. At such occasions the following process can be > >> seen with "top", taking 99% of the CPU resources: > >> > >> phsh-ko+ 59422 56031 11 16:30 ? 00:00:35 > >> /usr/share/koha/opac/cgi-bin/opac/opac-user.pl > >> > >> This happens more often when trying to login from the internal network, > >> and less often when trying to login from the external network (i. e. the > >> internet). > >> > >> Has anyone experienced this problem before and can maybe give us a hint > >> how to tame "opac-user.pl"? > >> > >> Best wishes and Happy Easter: Michael > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> [email protected] > >> https://lists.katipo.co.nz/mailman/listinfo/koha > >> > > _______________________________________________ > > Koha mailing list http://koha-community.org > > [email protected] > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
