# Mysql Review

> Review MySQL/MariaDB schemas, queries, and configuration for performance and production readiness

- Skill: `erp-core-dev/mysql-review` (Agent Skill)
- Install (CLI): `npx skillmds@latest add erp-core-dev/mysql-review`
- Raw SKILL.md: https://api.skillmd.com/api/skills/erp-core-dev/mysql-review/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ERP-CORE-DEV (https://skillmd.com/u/erp-core-dev)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/erp-core-dev/mysql-review

---


# MySQL / MariaDB Review

Review MySQL for query optimization, InnoDB tuning, replication, character sets, and security.

## Key Checks
- EXPLAIN FORMAT=JSON — flag type: ALL (full scan), Using filesort, Using temporary
- Composite index column order matches query left-prefix rule
- FULLTEXT indexes for LIKE '%term%', functional indexes for expressions (MySQL 8.0+)
- innodb_buffer_pool_size 70-80% RAM, innodb_flush_log_at_trx_commit, innodb_flush_method O_DIRECT
- binlog_format = ROW, GTID mode for replication, Seconds_Behind_Source monitoring
- utf8mb4 everywhere (not utf8 which is 3-byte), consistent collation across JOINs
- RANGE partitioning for dates, verify partition key in unique indexes
- No anonymous users, GRANT minimum privileges, require_secure_transport, validate_password STRONG

## Output
Severity-sorted: CRITICAL, HIGH, MEDIUM, LOW, PASSED.