mysql

To optimize slow MySQL queries, analyze execution plans and propose composite indexes to reduce table scans. This skill diagnoses slow queries by evaluating storage engines and character sets to output an actionable index plan and performance checks.

You need composite indexing for MySQL schema design when optimizing hot paths that filter or sort on multiple columns. This skill assesses data types, nullability, and primary key decisions to propose composite indexes that improve query performance.

The best way to plan safe online schema changes for MySQL is to evaluate replication topology and storage engine versions beforehand. This skill generates a migration plan that ensures production reliability during partitioning and schema modifications.

Yes, you can diagnose MySQL replication configuration by running a comprehensive health check. This skill evaluates replication topology alongside schema design and indexing strategy to output actionable optimization plans for reliability.

MySQL partitioning depends on storage engine compatibility and version constraints. This skill evaluates your MySQL version, storage engine, and character set during schema review to determine if partitioning is viable and safe for your setup.

Your MySQL health check requires reviewing character sets because they impact storage efficiency and query comparison behavior. This skill evaluates character sets alongside schema design and indexing strategy to output a comprehensive performance optimization plan.