skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

starrocks-admin-compaction

Diagnose StarRocks compaction bottlenecks via SQL views and BE endpoints.

14|1|Updated May 5, 2026
Search Tags:#query performance#starrocks#primary key table#tablet monitoring#compaction tuning#write amplification#operational runbook
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-admin-compaction
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: starrocks-admin-compaction
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/starrocks_admin_compaction
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-admin-compaction

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you diagnose and fix StarRocks compaction backlogs that cause rising query latency, disk space pressure from accumulated rowsets, and stalled or inefficient merges on BE nodes.

Core Features & Use Cases

  • Compaction visibility and scoring: Interprets compaction score patterns and reads live task state via SQL (SHOW PROC '/compactions', SHOW TABLET ... STATUS', information_schema.be_compactions) and BE APIs to identify high-urgency tablets.
  • Operational tuning and configuration: Guides BE parameter adjustments for compaction threads and thresholds (cumulative vs base), plus Primary Key Table (PKT) delete vector compaction controls.
  • Safe remediation workflows: Covers manual triggers at table/partition/tablet scope (ALTER TABLE ... COMPACT, BE HTTP endpoints), along with monitoring (Prometheus/Grafana) and troubleshooting for stuck compactions and I/O saturation.

Quick Start

Use this skill to determine whether you need cumulative or base compaction, identify the worst tablets/BE nodes, and decide the safest manual trigger or BE configuration change to reduce compaction score.

Frequently Asked Questions about starrocks-admin-compaction

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

FAQPage Schema
How do I diagnose StarRocks compaction bottlenecks causing high query latency?▼

Diagnose StarRocks compaction bottlenecks by analyzing compaction scores and live tablet task states using SQL views like SHOW PROC '/compactions' and information_schema.be_compactions to identify high-urgency tablets.

How do I manually trigger compaction on a StarRocks table or partition?▼

Trigger StarRocks compaction manually at table, partition, or tablet scope using ALTER TABLE COMPACT statements or BE HTTP endpoints to resolve stalled merges and reduce disk pressure after ingestion bursts.

What is the difference between cumulative and base compaction in StarRocks?▼

Cumulative compaction merges smaller rowsets to limit write amplification, while base compaction merges all rowsets into a single base rowset to restore storage efficiency and query performance when thresholds are met.

Why are Primary Key Table compactions stalling and accumulating delete vectors in StarRocks?▼

Primary Key Table compaction stalls when delete vector controls and BE configuration parameters are misconfigured, requiring operational threshold tuning and rowset behavior analysis to restore merge progress.

How do I tune StarRocks BE compaction threads and thresholds to prevent I/O saturation?▼

Tune StarRocks BE compaction threads and cumulative versus base thresholds by adjusting configuration parameters to meet operational thresholds, preventing I/O saturation and resolving stuck compactions.

Related Skills

Explore More Software Engineering Skills→
ivanshamaevivanshamaev
14

starrocks-self-healing

Restart transiently paused StarRocks Routine Load jobs and remediate ingestion health issues.

Community
Advanced
ivanshamaevivanshamaev
14

starrocks-admin-cluster-health

Diagnose StarRocks cluster health via SHOW, ADMIN, and Information_Schema queries.

Community
Advanced
StarRocksStarRocks
73

tablet

Diagnose StarRocks tablet health, skew, and balance failures.

Official
Advanced
StarRocksStarRocks
73

compaction

Diagnose StarRocks compaction backlog and version-explosion failures using metrics, SQL, and logs.

Official
Advanced