Skip to content

Archiving status: Reexpire lock only when needed #15747

@tsteur

Description

@tsteur

@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
image

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.

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions