# Mysql

> MySQL database administration and development

- Skill: `majiayu000/mysql` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/mysql`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/mysql/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/mysql

---


# MySQL Skill

## Overview
Master MySQL database administration, optimization, and development for production environments.

## Topics Covered

### MySQL Basics
- Installation and configuration
- User management
- Database creation
- Storage engines (InnoDB, MyISAM)
- Character sets

### Query Development
- SELECT statements
- JOINs and subqueries
- INSERT, UPDATE, DELETE
- Stored procedures
- Triggers and events

### Performance
- EXPLAIN analysis
- Index optimization
- Query cache (8.0+ changes)
- Slow query log
- Performance Schema

### Administration
- Backup with mysqldump
- Binary log management
- Replication setup
- User privileges
- Configuration tuning

### High Availability
- MySQL replication
- Group replication
- MySQL Router
- ProxySQL
- Failover strategies

## Prerequisites
- SQL fundamentals
- Linux basics
- Networking concepts

## Learning Outcomes
- Administer MySQL servers
- Optimize queries
- Set up replication
- Manage backups