pt-stalk magical algorithm

Registered by Baron Schwartz on 2012-01-09

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

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.