[Koha-bugs] [Bug 18821] TrackLastPatronActivity is a performance killer

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue May 29 14:09:17 CEST 2018


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18821

--- Comment #33 from Kyle M Hall <kyle at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #32)
> Before continuing here I think we should first confirm that the code is the
> cause of the problem.
> 
> I have talked with Nick last month and it seemed that it came from somewhere
> else:
> 
> """
> Errors in the logs "DBD::mysql::db begin_work failed: Already in a
> transaction" - it seemed to increase during heavy circ periods - DB was
> slowed by constant hits and then clashes
> """
> 
> It does not sound related to this code, but more to rebuild_zebra.pl that
> uses AutoCommit instead of a DBIC transaction.

While that may be true, it does not change the fact that this feature *is* a
performance killer. We've seen multiple instances of slow servers that having a
immediate speed improvement simply by disabling this feature!

Nothing about transactions has been mentioned on this bug previously, are you
sure you are commenting on the correct bug?

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list