Profile application requests to see what kind of read/write DB traffic we should expect
Open, MediumPublic
Actions

Assigned To

None

Authored By

	dduvall
	Mar 3 2016, 8:33 PM

Description

(see T127390: Meet with Security and Ops about a long-term productionization plan for background)

To better accommodate the dashboard database under in Labs, we'll need to know a little more about its traffic profile.

@Ragesoss, would it be possible to get some aggregates from your production logs to get a better sense of controller#action hits and so forth? I've used request-log-analyzer in the past but I've no idea if that's a viable option anymore.

Related Objects

Mentioned In: T128792: Investigate Tool Labs as an option for running the Program Dashboard
Mentioned Here: T127390: Meet with Security and Ops about a long-term productionization plan

Event Timeline

dduvall created this task.Mar 3 2016, 8:33 PM

dduvall updated the task description. (Show Details)

dduvall mentioned this in T128792: Investigate Tool Labs as an option for running the Program Dashboard.Mar 3 2016, 9:25 PM

dduvall edited projects, added Programs-and-Events-Dashboard-Sprint 2; removed Program Dashboard Sprint 1.Mar 4 2016, 9:55 PM

Here's some database profiling from Wiki Ed production for 24 hours. The lion's share of the transactions are probably part of the data update process (which gets more intense as the number of students in active courses, and their number of revisions and articles, grows), rather than being driven directly by website users.