[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