metrics for read/write queries on buildbot and buildbot_schedulers databases on tm-b01-master01 and tm-b01-slave01

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: catlee, Assigned: sheeri)

Tracking

Details

(Reporter)

Description

6 years ago
As per https://bugzilla.mozilla.org/show_bug.cgi?id=703365#c3, it would be really helpful to get some numbers on what our read/write ratio is like for our two main databases, both on the master and the slave.
(Reporter)

Updated

6 years ago
Summary: metrics for reiad/write queries on buildbot and buildbot_schedulers databases on tm-b01-master01 and tm-b01-slave01 → metrics for read/write queries on buildbot and buildbot_schedulers databases on tm-b01-master01 and tm-b01-slave01
Assignee: server-ops-releng → server-ops-database
Component: Server Operations: RelEng → Server Operations: Database
QA Contact: zandr → cshields
Assignee: server-ops-database → mpressman
Blocks: 707203
(Assignee)

Updated

6 years ago
Assignee: mpressman → scabral
(Assignee)

Comment 1

6 years ago
The best way to do this would be to turn slow query logging to have a 0 threshold for a sample period of time.  What would the best sample day/time/duration be?  (as it's a ratio, my guess is that a few hours, any day of the week, would be fine, but I defer to folks who know the app usage better than I do).
(Assignee)

Comment 2

6 years ago
Ugh, I completely forgot that MySQL 5.0.77 doesn't allow a long_query_time of 0, 1 is the lowest value.

I can just do this based on Com_ variables:

The master has about 81.8% reads, 18.2% writes (or a ratio of approx 4.5:1 reads:writes).

The slave has about 

The slave has about 72.5% *writes*, 17.5% reads, or a ration of approx 2.5:1 writes:reads.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.