Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add SQL diagnosis rule: threshold check for tikv_append_log_duration #17941

Open
crazycs520 opened this issue Jun 11, 2020 · 0 comments · May be fixed by #28726
Open

Add SQL diagnosis rule: threshold check for tikv_append_log_duration #17941

crazycs520 opened this issue Jun 11, 2020 · 0 comments · May be fixed by #28726
Labels
good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/enhancement The issue or PR belongs to an enhancement.

Comments

@crazycs520
Copy link
Contributor

crazycs520 commented Jun 11, 2020

Development Task

When Raft append log duration, P99 Value > 500ms, then append an warning in INSPECTION_RESULT table, this may be caused by:

  • write disk too slow, check the disk latency.
  • It may trigger the RocksDB Write Stall.

Refer

  • You can query the tikv_append_log_duration table to get metrics_schema.tikv_append_log_duration value. Here is the related doc.
  • You can refer the thresholdCheckInspection implementation in TiDB.

If you have any questions or want to discuss something, you can chat in the sig-dashboard slack channel and @ chenshuang.

@crazycs520 crazycs520 added the type/enhancement The issue or PR belongs to an enhancement. label Jun 11, 2020
@crazycs520 crazycs520 added difficulty/easy help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels Jun 11, 2020
@tisonkun tisonkun added good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. and removed difficulty/easy labels Sep 1, 2021
@7yyo 7yyo linked a pull request Oct 11, 2021 that will close this issue
12 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants