txn: Tracking issue for aggregating & persisting lock view for supporting diagnosing historical problems
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
- [x] Support calculating transaction digest for each transaction (#28835 and #36026)
- [ ] Persist lock-waiting and conflict status among transactions to [ng-monitoring](https://github.com/pingcap/ng-monitoring).
- [ ] ngm pull and store transaction digests to statemens mapping and store them in document db.
- [ ] ngm pull trx_id to transaction digests mapping and store them in memory(?).
- [ ] ngm pull, aggrate and store deadlock infomation into time seris db.
- [ ] ngm pull, aggrate and store lock wait infomation into time seris db.
- [ ] Dashboard support.
- [ ] Deadlock page.
- [ ] LockWait page.
- [ ] Connect slow sql's lock waiting time with LockWait page.
Contributor guide
Assessment
This issue has not been assessed yet.