-
-
Notifications
You must be signed in to change notification settings - Fork 2.7k
Closed
Labels
c: PerformanceFor when we could improve the performance / speed of Matomo.For when we could improve the performance / speed of Matomo.
Milestone
Description
@diosmosis I don't 100% remember anymore why the ArchivingStatus lock was needed?
However, I see we often get heaps of lock timeouts. And these locks often take a considerable amount of load on our DB servers. Eg
Often even more than any other query. Often causing a lot of lock wait timeout, and potentially even deadlocks.
Should this lock really still be needed (looked at code again and wasn't sure where it was actually used).
Maybe in ArchivingDbAdapter
it could be a start to not reexpire the lock on every DB query but maybe every 10 minutes or 30 minutes considering the lock is valid for up to 7200s by default?
Metadata
Metadata
Assignees
Labels
c: PerformanceFor when we could improve the performance / speed of Matomo.For when we could improve the performance / speed of Matomo.