pingcap / pingcap/tidb

txn: Tracking issue for aggregating & persisting lock view for supporting diagnosing historical problems

Open
#34,457 0 comments 0 reactions 0 assignees View on GitHub
type/enhancement
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.