mariadb-errors-slow-queries

Official

Diagnose and optimize slow MariaDB queries

AuthorImpertio-Studio
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps diagnose and optimize slow MariaDB queries by analyzing slow query logs, performance schema data, and EXPLAIN output.

Core Features & Use Cases

  • Slow Query Log Analysis: Enable, configure, and analyze slow query logs to identify slow queries.
  • Performance Schema: Utilize performance schema to profile query performance and detect bottlenecks.
  • EXPLAIN Output Analysis: Interpret EXPLAIN output to understand query execution plans and identify potential issues.
  • Use Case: If you notice that a particular query is consistently slow, use this Skill to enable the slow query log, analyze the query using EXPLAIN, and identify missing indexes or suboptimal query plans.

Quick Start

Use the mariadb-errors-slow-queries skill to enable slow query logging on your MariaDB instance with the command 'mariadb-errors-slow-queries enable_slow_logging'.

Dependency Matrix

Required Modules

pt-query-digest

Components

scriptsreferences

💻 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: mariadb-errors-slow-queries
Download link: https://github.com/Impertio-Studio/MariaDB-Claude-Skill-Package/archive/main.zip#mariadb-errors-slow-queries

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 620,000+ vetted skills library on demand.