mysql-performance

What problem does it solve?

Helps engineers quickly identify and remediate MySQL performance bottlenecks by analyzing active queries, slow query logs, EXPLAIN plans, and configuration metrics so that production Laravel applications stop being slowed by inefficient queries or misconfigured buffers.

Core Features & Use Cases

• Query triage: Inspect SHOW PROCESSLIST, find long-running queries and safely kill or cancel problematic statements.
• Slow log analysis: Enable and analyze the slow query log, surface top time-consuming statements, and prioritize fixes.
• Execution plan review: Use EXPLAIN, EXPLAIN FORMAT=JSON, and EXPLAIN ANALYZE to detect full table scans, filesorts, and large row estimates.
• Safe index changes: Recommend and craft non-blocking index strategies including inplace/online ALTER alternatives and using pt-online-schema-change or gh-ost for large tables.
• Laravel-specific diagnostics: Detect N+1 queries, leverage query listeners or Telescope, and suggest caching with Redis for heavy aggregated results.
• Operational guardrails: Advise on InnoDB buffer pool sizing, deadlock inspection, and never running risky commands like OPTIMIZE TABLE without a maintenance window.

Quick Start

Ask the skill to analyze the MySQL slow query log and EXPLAIN the top slow queries with recommended safe index and configuration changes for production.