mysql_skill

Overview

This skill teaches MySQL database administration, optimization, and development for production environments. It focuses on practical tasks like installation, backup, replication, and query tuning to keep databases reliable and performant.

How this skill works

It inspects schema design, query patterns, server configuration, and runtime diagnostics to recommend improvements. The skill provides step-by-step guidance for tasks such as setting up replication, analyzing EXPLAIN output, tuning indexes, and configuring backups.

When to use it

• Setting up a new MySQL server or tuning an existing instance for production
• Diagnosing slow queries and optimizing index and execution plans
• Designing schemas and choosing appropriate storage engines and character sets
• Implementing backup strategies and configuring binary logs or point-in-time recovery
• Configuring replication, group replication, or failover for high availability

Best practices

• Use EXPLAIN to analyze query execution plans before adding indexes
• Prefer InnoDB for transactional workloads and enable proper innodb_buffer_pool_size
• Keep backups automated and test restores regularly using mysqldump or physical copies
• Limit privileges with least-privilege user accounts and audit changes
• Monitor slow query log and Performance Schema for proactive performance tuning

Example use cases

• Optimize a slow reporting query by identifying missing indexes and rewriting joins
• Migrate a single-master setup to group replication for automated failover
• Design a multi-tenant schema with appropriate character sets and indexing strategies
• Automate daily backups and configure binary log retention for point-in-time recovery
• Tune server parameters (buffer pool, connection limits) for higher concurrency