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.

Sign up for GitHub

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

Jump to bottom

Improve the observability of resource control #49318

Closed
16 of 18 tasks
nolouch opened this issue Dec 11, 2023 · 0 comments
Closed
16 of 18 tasks

Improve the observability of resource control #49318

nolouch opened this issue Dec 11, 2023 · 0 comments
Labels
affects-7.5 component/pd type/enhancement The issue or PR belongs to an enhancement.

Comments

@nolouch
Copy link
Member

nolouch commented Dec 11, 2023 •
edited
Loading

Enhancement

System table

Log:

Metrics @bufferflies

To check the service quality: #50086

  • QPS & TPS by resource groups
  • P99/P95 by resource groups
  • DML latency by resource groups
  • command by resource groups
  • Failed command by resource groups
  • Connection Count by resource groups

Dashboard @nolouch

TiFlash

Runtime

Docs
@nolouch nolouch added the type/enhancement The issue or PR belongs to an enhancement. label Dec 11, 2023
This was referenced Dec 11, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Dec 13, 2023
@glorv
executor: add ru details in slow log and INFORMATION_SCHEMA.SLOW_QUERY (
161107a 
#49067)

close #42892, ref #49318
@glorv glorv mentioned this issue Dec 13, 2023
Merged
13 tasks
@bufferflies bufferflies mentioned this issue Dec 13, 2023
Merged
4 tasks
@glorv glorv mentioned this issue Dec 15, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Dec 21, 2023
@glorv
session: add resource group name in stmt context (#49422)
b27587e 
close #49318
@glorv glorv reopened this Dec 21, 2023
@glorv glorv mentioned this issue Dec 21, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Dec 22, 2023
@glorv
metrics: change background resource group label name (#49654)
4073030 
ref #49318
@glorv glorv mentioned this issue Dec 25, 2023
Closed
ti-chi-bot bot pushed a commit that referenced this issue Dec 25, 2023
@glorv
stmtsummary: add request-units info in statements_summary (#49504)
946bcfc 
ref #49318
@nolouch nolouch mentioned this issue Dec 25, 2023
Merged
3 tasks
@glorv glorv mentioned this issue Dec 27, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Dec 27, 2023
@glorv
*: update pd-client and client-go (#49833)
ed291b8 
ref #49318
@glorv glorv mentioned this issue Dec 28, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 3, 2024
@bufferflies
metrics: add connection and fail metrics by resource group name (#4…
e803852 
…9424)

ref #49318
ti-chi-bot bot pushed a commit that referenced this issue Jan 3, 2024
@nolouch
*: add last ru consumption for tidb_last_query_info (#49769)
33480e8 
ref #49318
@nolouch nolouch mentioned this issue Jan 4, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 4, 2024
@nolouch
*: remove duplicate prefix for last query info (#50075)
7a8d82e 
ref #49318
@bufferflies bufferflies mentioned this issue Jan 4, 2024
Merged
4 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 4, 2024
@glorv
domain: support inserting ru historical data into mysql.request_unit_…
a1fd1be 
…by_group periodically (#49873)

ref #49318
@ti-chi-bot ti-chi-bot mentioned this issue Jan 5, 2024
Merged
4 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 11, 2024
@bufferflies
metrics: add new row panel for tidb query (#50086)
190488d 
ref #49318
This was referenced Jan 11, 2024
Merged
Merged
This was referenced Feb 18, 2024
Closed
Closed
ti-chi-bot bot pushed a commit that referenced this issue Feb 18, 2024
@ti-chi-bot
executor: add ru details in slow log and INFORMATION_SCHEMA.SLOW_QUERY (
b4a73d5 
#49067) (#50881)

close #42892, ref #49318
ti-chi-bot bot pushed a commit that referenced this issue Feb 19, 2024
@ti-chi-bot
session: add resource group name in stmt context (#49422) (#51117)
eeef0ee 
ref #49318
ti-chi-bot bot pushed a commit that referenced this issue Feb 19, 2024
@ti-chi-bot
metrics: add connection and fail metrics by resource group name (#4…
24a9caa 
…9424) (#50124)

ref #49318
ti-chi-bot bot pushed a commit that referenced this issue Feb 19, 2024
@ti-chi-bot
metrics: change background resource group label name (#49654) (#51119)
081ea9a 
ref #49318
ti-chi-bot bot pushed a commit that referenced this issue Feb 19, 2024
@ti-chi-bot
stmtsummary: add request-units info in statements_summary (#49504) (#…
def88be 
…50879)

ref #49318
ti-chi-bot bot pushed a commit that referenced this issue Feb 20, 2024
@ti-chi-bot
metrics: add new row panel for tidb query (#50086) (#50319)
53b15c5 
ref #49318
nolouch added a commit to ti-chi-bot/tidb that referenced this issue Feb 20, 2024
@nolouch
*: remove duplicate prefix for last query info (pingcap#50075)
c200830 
ref pingcap#49318
ti-chi-bot bot pushed a commit that referenced this issue Feb 20, 2024
@ti-chi-bot
*: add last ru consumption for tidb_last_query_info (#49769) (#51120)
89653fb 
ref #49318
@nolouch nolouch closed this as completed Mar 21, 2024
@nolouch nolouch mentioned this issue Mar 22, 2024
Merged
5 tasks
ti-chi-bot bot pushed a commit that referenced this issue Mar 22, 2024
@nolouch
metrics: Add a RU(max) panel to observe maximum resource consumption (#…
69fa424 
…52007)

ref #49318
This was referenced Apr 1, 2024
Merged
Merged
This was referenced Apr 18, 2024
Closed
Closed
Closed
Closed
Closed
Closed
Closed
Closed
ti-chi-bot bot pushed a commit that referenced this issue Apr 18, 2024
@ti-chi-bot
metrics: Add a RU(max) panel to observe maximum resource consumption (#…
afb5e40 
…52007) (#52287)

ref #49318
nolouch added a commit to ti-chi-bot/tidb that referenced this issue Apr 18, 2024
@nolouch
metrics: Add a RU(max) panel to observe maximum resource consumption (p…
aac50c4 
…ingcap#52007) (pingcap#52287)

ref pingcap#49318
ti-chi-bot bot pushed a commit that referenced this issue Apr 18, 2024
@ti-chi-bot
metrics: Add a RU(max) panel to observe maximum resource consumption (#…
b5825e7 
…52007) (#52288)

ref #49318
@nolouch nolouch mentioned this issue May 29, 2024
Merged
5 tasks
ti-chi-bot bot pushed a commit that referenced this issue May 29, 2024
@nolouch
mod: update pd client (#53639)
5c6ee34 
close tikv/pd#8217, ref #49318
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-7.5 component/pd type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@jebter @glorv @nolouch @ti-chi-bot