Closed Bug 949555 (leaderboard-query++) Opened 10 years ago Closed 9 years ago

Engagement cluster improvement on a query

Categories

(Firefox Affiliates Graveyard :: affiliates.mozilla.org, defect)

defect
Not set
normal

Tracking

(Not tracked)

RESOLVED WONTFIX

People

(Reporter: bjohnson, Unassigned)

References

Details

The engagements cluster has a query that could be improved for data consistency across the cluster. The query that builds the affiliates_mozilla_org.badges_leaderboard table has an order by clause. It's order by count(clicks), it can be improved to be order by count(clicks), user_id. What's happening is the order is being randomized (daily and per db server) for people who have the same count of clicks.

This randomizes the order for people who have the same click count. It also randomizes it within each database node within the cluster so data is not 100% consistent across db nodes.
i don't know if there are any (dev) active resources on affiliates, but i am copying :mkelly for his thoughts here.
Flags: needinfo?(mkelly)
OS: Mac OS X → All
Hardware: x86 → All
Agreed that this is something we should change, especially for the consistency issues. Moving this to Affiliates as this is our issue.

I talked with cyborgshadow on IRC about this and he agreed that this can wait until the Affiliates redesign/cleanup in 2014Q1, so we'll add it to the tracking bug for those efforts once it exists.
Assignee: server-ops-webops → nobody
Component: WebOps: Engagement → affiliates.mozilla.org
Flags: needinfo?(mkelly)
Product: Infrastructure & Operations → Firefox Affiliates
QA Contact: nmaul
Target Milestone: --- → 5
Alias: leaderboard-query++
Blocks: build-affiliates-2.0
No longer blocks: affiliates-2.0
Target Milestone: 5 → ---
All work on Firefox Affiliates is on hold as the Affiliates program is slated to be phased out in 2015
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → WONTFIX
Product: Firefox Affiliates → Firefox Affiliates Graveyard
You need to log in before you can comment on or make changes to this bug.