Closed Bug 773541 Opened 12 years ago Closed 11 years ago

Collect metrics on DB connection-pool usage

Categories

(Cloud Services Graveyard :: Server: Sync, defect)

x86
Linux
defect
Not set
normal

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: rfkelly, Assigned: rfkelly)

References

Details

(Whiteboard: [qa-])

Attachments

(2 files)

For example: how often an existing connection is used vs a new one created, how often the pool is invalidated and re-populated.
Whiteboard: [qa-]
fix bug title; something is up with my grammar these days...
Summary: Collection metrics on DB connection-pool usage → Collect metrics on DB connection-pool usage
also how long you wait in the backlog queue, and stats on connection invalidation.
Patch to server-core that increments a metlog counter on each query retry.
Attachment #728509 - Flags: review?(telliott)
server-storage patch to collect various connection-pool-related stats, including time spent waiting for a connection, number of connections created, number of timeouts and backlog errors, etc.
Attachment #728510 - Flags: review?(telliott)
Attachment #728509 - Flags: review?(telliott) → review+
Attachment #728510 - Flags: review?(telliott) → review+
http://hg.mozilla.org/services/server-storage/rev/8c8126677469
http://hg.mozilla.org/services/server-core/rev/5fcd69fdcb2d

Resolving fixed, but we need to verify that these metrics are actually getting collected.  Will summarize how to do this in the containing deployment bug, when I create one.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
These metrics are now included in the pencil graphs for stage, and they appear to be sensibly behaved under some light load.
Verified across PHX1 and SCL2 - I can see Connection Pool data in Pencil.
Status: RESOLVED → VERIFIED
Product: Cloud Services → Cloud Services Graveyard
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: