Skills
.Work. You
Rest

mysql-query-optimization

Official

Diagnose slow queries & optimize indexes

Software Engineering#indexing#mysql#query-optimization#slow-queries#percona-server#pt-query-digest
AuthorPercona-Lab
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Diagnosing slow queries and designing effective indexing strategies on Percona Server for MySQL to improve performance and resource utilization.

Core Features & Use Cases

  • Analyze slow query logs with EXPLAIN ANALYZE, extended slow log, and optimizer histograms to identify bottlenecks.
  • Evaluate index usage, discover missing or redundant indexes, and plan changes with measurable impact.
  • Leverage Percona-specific diagnostics (userstat, log_slow_verbosity) together with pt-query-digest and PMM Query Analytics to validate improvements.

Quick Start

Run a representative workload on Percona Server for MySQL and review the extended slow query log and per-table statistics to prioritize index changes.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: mysql-query-optimization
Download link: https://github.com/Percona-Lab/skills/archive/main.zip#mysql-query-optimization

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.