Have pt-stalk collect performance_schema.threads along with information_schema.processlist
General
Escalation
General
Escalation
Description
User story: As a pt-stalk user, I need to see threads information along with processlist, so that simplifies problem investigations
UI/UX: ???
Acceptance criteria TBD
Out of scope: TBD
Suggested implementation: TBD
How to test: TBD
Details: TBD
Original report:
Having pt-stalk collect threads information along with processlist helps in narrow down investigation, and allows insight into threads that might be holding locks/semaphores that are not otherwise visible.
Environment
None
Smart Checklist
Activity
Show:
Michael Coburn March 17, 2021 at 2:37 PM
Hi -
pt-stalk stores output in individual text files during a collection. So all that should be needed is:
Jira Bot March 16, 2021 at 8:55 PM
To: CC:
Hi, I'm jira-bot, Percona's Jira automation tool. I've detected that someone from Percona has made an edit to the Summary field of an issue that you reported.
I'm not sentient (yet) so I'm not sure whether the person fixed a typo, changed a few words, or completely rewrote the text. In any case, it is Percona Engineering's intention to make the Summary and Description of an issue as accurate as possible so that we're fixing the actual problem you're encountering, and to avoid misunderstandings about symptoms and causes.
If the current Summary does not accurately reflect the problem you are reporting, or if you feel the change was otherwise inappropriate in some way, please add a new comment explaining things and we'll address it as soon as we can.
This message will be added only once per issue, regardless of how many times the Summary is edited.
message-code:summary-edited
Roma Novikov March 16, 2021 at 8:55 PM
can you help with ideas/suggestions on how the UX for this should like?
User story:
As a pt-stalk user, I need to see threads information along with processlist, so that simplifies problem investigations
UI/UX:
???
Acceptance criteria
TBD
Out of scope:
TBD
Suggested implementation:
TBD
How to test:
TBD
Details:
TBD
Original report:
Having pt-stalk collect threads information along with processlist helps in narrow down investigation, and allows insight into threads that might be holding locks/semaphores that are not otherwise visible.