[Koha] Slow Koha OPAC login process

[Jonathan Druart]

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 <mik at adminkuhn.ch> 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 <mik at adminkuhn.ch> 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
> >> Koha at lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>