pt-stalk magical algorithm
Registered by
Baron Schwartz
Create a magical trigger function
The magical trigger function will watch SHOW STATUS and track these variables:
a. Queries
b. Threads_running
c. Threads_connected
Queries must be tracked between samples, so it subtracts the last sample from
the current sample, divides by elapsed time, and obtains queries per second.
Each of these should be turned into a long-term exponentially decaying average,
by keeping an accumulator variable. When all three of them cross a threshold,
the tool triggers. The exact definition of the threshold is to be specified
later after more research.
Blueprint information
- Status:
- Complete
- Approver:
- Baron Schwartz
- Priority:
- High
- Drafter:
- Daniel Nichter
- Direction:
- Needs approval
- Assignee:
- Daniel Nichter
- Definition:
- Obsolete
- Series goal:
- None
- Implementation:
- Started
- Milestone target:
- None
- Started by
- Daniel Nichter
- Completed by
- Daniel Nichter
Related branches
Related bugs
Sprints
Whiteboard
(?)