---

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.