update-pkgcache.py needs to be database friendly

Bug #517101 reported by Stuart Bishop
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
High
Unassigned

Bug Description

update-pkgcache.py makes a lot of database changes very rapidly. This is putting undue stress on our replication system. We should slow it down to lessen its impact on the rest of the system, ideally by refactoring it to use DBLoopTuner.

Tags: lp-soyuz
Changed in soyuz:
status: New → Triaged
importance: Undecided → High
milestone: none → 10.03
Changed in soyuz:
assignee: nobody → Jelmer Vernooij (jelmer)
milestone: 10.03 → pending
Jelmer Vernooij (jelmer)
Changed in launchpad:
assignee: Jelmer Vernooij (jelmer) → nobody
Revision history for this message
Robert Collins (lifeless) wrote :

Another possibility is to revisit the denormalisations it does and make them maintained incrementally (or even eliminate them, if they are not pulling their weight)

Revision history for this message
Stuart Bishop (stub) wrote :

Also Bug #912144 - it is holding open database transactions for too long causing fastdowntime deployment issues.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.