obdiag-performance

Name: obdiag-performance
Availability: InStock
Author: OceanBase

Aggregates ASH, sysstat, disk IO and flame graphs to identify OceanDB bottlenecks.

161|40|Updated Nov 22, 2022

Search Tags:#diagnostics #ash #perf #flame-graph #sysstat #awr #host-load

Ready to run

npx skills add https://github.com/oceanbase/obdiag --skill obdiag-performance

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: obdiag-performance
Source: https://github.com/oceanbase/obdiag/tree/main/plugins/agent/skills/obdiag-performance
Command: npx skills add https://github.com/oceanbase/obdiag --skill obdiag-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Performance diagnostics for OceanBase clusters by collecting host IO data (ASH, AWR, perf flame graphs, sysstat, disk IO) to pinpoint bottlenecks and slow paths.

Core Features & Use Cases

ASH data collection for active session analysis
AWR reporting and historical workload insights
Perf flame graphs for CPU/system call hot spots
Sysstat-based host baseline and load metrics
Disk I/O monitoring and IO wait characterization
Complementary tooling with observer-sql-analysis and observer-log-analysis

Quick Start

Run gather_ash for the current time window to start collecting host performance data.

Frequently Asked Questions about obdiag-performance

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

FAQPage Schema

How do I diagnose high host load and slow queries in OceanBase deployments?▼

Diagnose OceanBase host load and slow queries by aggregating ASH, AWR, perf flame graphs, sysstat, and disk IO data to pinpoint system bottlenecks. It correlates server-side performance metrics with host-side load to identify root causes of latency and session buildup.

What is the best way to identify CPU and system call hot spots in OceanBase?▼

Identify CPU and system call hot spots in OceanBase by collecting and analyzing perf flame graphs. This visualizes CPU consumption across active threads to reveal which internal functions or system calls consume the most processing time during peak load.

Can I collect ASH and AWR data for active session analysis in OceanBase?▼

Collect ASH and AWR data for active session analysis and historical workload insights in OceanBase. Running gather_ash captures current active session activity, while gather_awr generates historical workload reports to establish performance baselines.

Does OceanBase performance diagnostics work with disk IO monitoring tools?▼

OceanBase performance diagnostics works with disk IO monitoring by running tool_io_performance to characterize IO wait and throughput. It aggregates sysstat host baseline metrics to correlate disk IO bottlenecks with overall host load and query latency.

When do I need to run root cause analysis alongside host performance diagnostics in OceanBase?▼

Run root cause analysis alongside host performance diagnostics when OceanBase latency, session buildup, or high host load persists after initial bottleneck identification. Coordinating rca_run with check_cluster validates cluster configuration and isolates systemic deployment issues.