obdiag V2.0.0|V3.0.0|OceanBase Diagnostic Tool

Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

OceanBase Diagnostic Tool

V3.0.0

Overview
Install obdiag
Configure obdiag
One-click Cluster Inspection
- Use obdiag to inspect an OceanBase cluster
- Inspection metrics
One-click Information Collection
- One-click General Information Collection
  - obdiag gather log
  - obdiag gather sysstat
  - obdiag gather plan_monitor
  - obdiag gather stack
  - obdiag gather perf
  - obdiag gather ash
  - obdiag gather tabledump
  - obdiag gather parameter
  - obdiag gather variable
  - obdiag gather clog/obdiag gather slog
  - obdiag gather obproxy_log
  - obdiag gather all
- One-click Scenario-based Information Collection
  - observer.perf_sql
  - observer.clog_disk_full
  - observer.backup
  - observer.rootservice_switch
  - observer.long_transaction
  - observer.perf_sql
  - observer.unit_data_imbalance
  - observer.suspend_transaction
  - observer.log_archive
  - observer.unknown
  - observer.base
  - observer.io
  - observer.recovery
  - observer.backup_clean
  - other.application_error
  - observer.cpu_high
  - observer.memory
  - obproxy.restart
  - observer.cluster_down
  - Overview
  - observer.delay_of_primary_and_backup
  - observer.px_collect_log
  - observer.topsql
  - observer.restart
  - observer.compaction
One-click Diagnostic Analysis
- obdiag analyze log
- obdiag analyze flt_trace
- obdiag analyze parameter default
- obdiag analyze parameter diff
- obdiag analyze variable diff
- obdiag analyze index_space
- obdiag analyze memory
- obdiag analyze queue
One-click Root Cause Analysis
- major_hold
- clog_disk_full
- Use obdiag for root cause analysis
- transaction_not_ending
- index_ddl_error
- transaction_execute_timeout
- log_error
- ddl_failure
- transaction_disconnection
- transaction_wait_timeout
- transaction_rollback
- transaction_other_error
- disconnection
- lock_conflict
- oms_full_trans
- ddl_disk_full
One-click Cluster Display
- Information about zones in a cluster
- RootService information of a cluster
- Information about the process list in a cluster
- Information about the execution plan of an SQL statement
- Basic information of a cluster
- Information about units in a cluster
- Overview
- Information about locks in a cluster
- Information about tenants in a cluster
- Information about nodes in a cluster
- Information about slow SQL statements in a cluster
- Disk usage of the specified table in a database
- Disk usage of a database
- Information about top SQL statements in a cluster
- Information about tables in a cluster
- Information about events in a cluster
Upgrade obdiag by using add-on files
Upgrade and uninstall obdiag
Telemetry Mode
FAQ
Release Notes
- obdiag V3.0.0
- obdiag V2.6.0
- obdiag V2.5.0
- obdiag V2.4.0
- obdiag V2.3.0
- obdiag V2.2.0
- obdiag V2.1.0
- obdiag V2.0.0
- obdiag V1.6.2
- obdiag V1.6.1
- obdiag V1.6.0
- obdiag V1.5.2
- obdiag V1.5.1
- obdiag V1.5.0
- obdiag V1.4.0
- obdiag V1.3.0