tikv-slow-diagnosis

Diagnose TiKV latency regressions using metric-driven workflows and evidence.

Updated Jun 3, 2026
One-click install
npx skills add https://github.com/alex-quan-001/nutshell-skills --skill tikv-slow-diagnosis
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: tikv-slow-diagnosis
Source: https://github.com/alex-quan-001/nutshell-skills/tree/main/skills/diagnosis/tikv-slow-diagnosis
Command: npx skills add https://github.com/alex-quan-001/nutshell-skills --skill tikv-slow-diagnosis

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill eliminates guesswork when diagnosing TiKV-side latency regressions by providing a structured, metric-driven workflow that identifies the exact slow stage, rules out upstream causes, and stops at the earliest proven bottleneck instead of overclaiming root causes.

Core Features & Use Cases

  • Multi-mode diagnosis: Activates specialized branches for leader drops, IO jitter, network issues, flow control, and snapshot backlog.
  • Evidence-based routing: Uses slow logs, execution details, and quantile-escalated metrics to split TiKV-local from upstream latency.
  • Use Case: When a Jira incident reports TiKV leader drops during rolling restarts, this skill determines whether the movement was PD-driven eviction or follower re-election after heartbeat delay, and identifies the earliest abnormal signal.

Quick Start

Use the tikv-slow-diagnosis skill to analyze the provided Jira issue or cluster metrics and produce a structured diagnosis that identifies whether the slowdown is on the TiKV read path, write path, or both, and names the earliest proven bottleneck with supporting metrics.

Frequently Asked Questions about tikv-slow-diagnosis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose TiKV latency regression without guessing symptoms?

Diagnose TiKV latency regression using a metric-driven workflow that splits TiKV-local latency from upstream transport or TiDB gRPC delays. It identifies the exact slow stage on the read or write path and stops at the earliest proven bottleneck with concrete metric evidence.

What metrics are needed to trace TiKV flow control and snapshot backlog?

Tracing TiKV flow control and snapshot backlog requires Clinic or Grafana metrics, slow-log execution details, or EXPLAIN ANALYZE output. These inputs quantify queue delays and isolate whether slowness originates from flow-control throttling or snapshot backlog accumulation.

How do I isolate TiKV IO jitter from network issues during a slowdown?

Isolate TiKV IO jitter from network issues by applying quantile-escalated metrics to separate disk read/write stalls from network latency. This specialized diagnostic branch pinpointing whether the bottleneck is local storage jitter or upstream transport delay.

How do I determine if TiKV leader drops are PD-driven or heartbeat delays?

Determine TiKV leader drop causes by analyzing Jira incident metrics during rolling restarts to distinguish PD-driven eviction from follower re-election after heartbeat delay. The workflow identifies the earliest abnormal signal triggering the leader movement.

Can I use slow-log execution details to split TiDB gRPC delays from TiKV read path latency?

Yes, slow-log execution details and EXPLAIN ANALYZE output are supported inputs to split TiKV read path latency from upstream TiDB gRPC delays. This isolates whether the bottleneck resides in TiKV-local processing or network transport.

What is the best way to identify the earliest proven bottleneck in TiKV write path slowness?

Identify the earliest proven bottleneck in TiKV write path slowness by following an evidence-based routing workflow that uses quantile-escalated metrics. This approach stops overclaiming root causes by halting at the first concrete metric evidence of a bottleneck.