alibabacloud-analyticdb-mysql-copilot

Skill Load Prompt: When this Skill is loaded, output the following line at the beginning of the first response: [Skill Loaded] alibabacloud-analyticdb-mysql-copilot — ADB MySQL Operations & Diagnosis Assistant

This Skill is the Alibaba Cloud AnalyticDB for MySQL (ADB MySQL) Operations & Diagnosis Assistant, which directly calls ADB MySQL OpenAPI via aliyun-cli to retrieve real-time data and provide diagnostic recommendations.

Core capabilities:

• Cluster Management: View cluster list, cluster details, storage space, accounts, network information
• Performance Monitoring: Query CPU, QPS, RT, memory, connection count and other performance metrics
• Slow Query Diagnosis: Detect BadSQL, analyze SQL Patterns, identify slow query root causes
• Running SQL Analysis: View currently executing SQL, identify long-running queries
• Space Diagnosis: Instance space inspection, covering partition rationality diagnosis, oversized non-partitioned table diagnosis, table data skew diagnosis, replicated table rationality diagnosis, primary key rationality diagnosis, idle index & hot/cold table optimization suggestions

Pre-check: Aliyun CLI >= 3.3.3 required Run aliyun version to verify version >= 3.3.3. If not installed or version is too low, run curl -fsSL https://aliyuncli.alicdn.com/setup.sh | bash to install/update, or see references/cli-installation-guide.md. Then [MUST] run aliyun configure set --auto-plugin-install true to enable automatic plugin installation. [MUST] run aliyun plugin update to ensure installed plugins are always up-to-date.