[Koha] Slow Koha OPAC login process

[Marc Véron]

Hi Michael

What version of Koha is it?

Do you have errors or messages  in the log files?
You can monitor them using tail. At first place I would have a look at 
opac-error.log and plack-error.log,
something like: tail -f opac-error.log

Kind regards
Marc


Am 17.04.2017 um 23:20 schrieb 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
>>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha