-
Notifications
You must be signed in to change notification settings - Fork 133
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
supports QPS/CPU dimension in keyviz #1209
Comments
cc @qidi1 @IcePigZDB |
Currently we have undecided about the future iteration of KeyViz, due to its requirement of professional ability. According to the scenario you described, how about simply using Top SQL to observe such hot spots directly? I tested with the payload you provided. Here is what I got from Top SQL: Here is what I got from KeyViz (it indeed shows zero read flow): Top SQL looks to be sufficient enough for troubleshooting such case. |
Yes, TopSQL can tell me that this SQL is consuming a lot of CPU. It's useful to the user, but it's not enough for an advanced user or expert. TopSQL cannot say it is a hotspot, the data may access randomly, and there is enough data to be distributed evenly on the TiKV nodes. so this type of SQL does consume a lot of CPU, but it may not cause a hotspot. We still need |
Thanks for the supply information. I totally agree "We still need KeyViz to show the workload pattern to help understand the hotspot". This looks to be extremely useful for PD developers to understand why such hotspots are not scattered.
Contributions are always welcome :) We can help reviewing PRs. I'm not sure whether there are CPU usage information in TiKV heartbeat. If such information is available, then the change may be small. |
…issues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…ues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
Signed-off-by: qidi1 <1083369179@qq.com>
…d/issues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…sues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…/issues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…d/issues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…sues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…sues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
…/issues/1209 Signed-off-by: qidi1 <1083369179@qq.com>
Feature Request
Is your feature request related to a problem? Please describe:
Currently,Keyviz has
keys
andbytes
dimensions. In some situations, it cannot find the hotspot that the CPU is high caused by QPS, thekeys
andbytes
may be 0. For example:Describe the feature you'd like:
Describe alternatives you've considered:
we can add QPS first. CPU after the TopSQL enable by default.
Teachability, Documentation, Adoption, Migration Strategy:
The text was updated successfully, but these errors were encountered: