| name | syn-mysql-tuning |
| description | Operate, configure, troubleshoot, and manage MySQL. Use for MySQL engineering tasks, day-to-day operations, and production support. |
MySQL: InnoDB buffer pool and server tuning
When to use
Use this skill for InnoDB buffer pool and server tuning in MySQL. This skill
specifically handles InnoDB buffer pool and server tuning and nothing else in the
MySQL family.
Procedure
Size innodb_buffer_pool_size, tune innodb_log_file_size and flushing, and adjust connection/thread settings from metrics.
Notes
This is the MySQL skill dedicated to InnoDB buffer pool and server tuning.
Sibling skills cover other MySQL capabilities; this one
is the right choice only when the task is about InnoDB buffer pool and server tuning.