openocta-db-ops-skills

Batch health inspection for multiple MySQL/TiDB instances. Checks connections, disk usage, replication status, slow query trends, and memory for all instances. Outputs a prioritized anomaly report with TOP N issues and actionable recommendations. Reduces full inspection from half a day to 10 minutes.

Capacity early warning with growth source attribution. Analyzes disk, connections, and QPS trends, breaks down growth by source (binlog, audit log, business data), predicts exhaustion date, and provides actionable recommendations per source. Turns "disk 92%" into "4 days to full — clear audit_log to free 54GB, buy 6 more days".

Full-chain MySQL deadlock analysis. Captures InnoDB status, parses lock chains, identifies deadlock patterns (AB-BA / Gap Lock / FK), finds current lock waits and long transactions, outputs structured report with fix recommendations. Supports MySQL 5.7+ performance_schema and 5.6 compatibility mode.

Replication lag root cause analysis with automated resolution workflow. Detects lag, identifies blocking queries on the master, presents KILL candidates with safety classification, and executes KILL only after double user confirmation. Reduces recovery from 20 minutes to 2 minutes.

Automated MySQL schema review tool. Scans all tables for common issues: missing primary key, wrong storage engine, non-utf8mb4 charset, redundant indexes, foreign key constraints, auto-increment overflow risk, and unpartitioned large tables. Outputs prioritized findings with fix SQL.

Slow query diagnosis with root cause analysis and index optimization recommendations. Identifies TOP N slow queries, analyzes scan efficiency, calculates index hit rate, and suggests covering indexes — turning a 20-minute manual diagnosis into 8 seconds.

Detects SQL queries with sudden duration spikes BEFORE they hit the slow query threshold. Compares recent (24h) vs baseline (7d) average execution time using performance_schema digest statistics. Finds "invisible performance killers" — queries that silently degrade without triggering any alert.

Comprehensive TiDB cluster inspection. Checks cluster topology, node health, slow queries, hot regions, TiKV storage status, PD scheduling, leader skew, and TopSQL drain (latency / execution count / memory). Outputs a full inspection report with prioritized findings. Compatible with TiDB v4.0+.