mysql-schema-and-query-tuning

Guides MySQL and InnoDB work end to end: choosing column types and primary keys, designing indexes, reading execution plans, tuning transactions and locking, partitioning large tables, and applying safe schema changes, connection pooling, and replication-aware reads. Use when creating or altering MySQL tables, indexes, or SQL statements, interpreting EXPLAIN output, diagnosing slow queries, deadlocks, lock waits, connection exhaustion, or replica lag, or planning a production migration. Not for non-MySQL databases such as PostgreSQL, for installing or provisioning servers, or for vendor-managed deploy workflows.

Version

v1.0.0

Size

23 KB

Updated

2026-10-06

Your client verifies the signature before reading. This explicit manual read is available on every plan. Free automatically loads five chosen skills; paid plans automatically load relevant skills across the library.