---
name: "mysql-innodb-buffer-pool-tuning"
description: "Tune MySQL 8 InnoDB storage engine parameters for high-concurrency transactional workloads."
metadata:
  author: "MySQL"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "tune mysql innodb buffer pool"
  - "configure innodb redo log capacity"
  - "optimize mysql for nvme"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# MySQL 8 InnoDB Buffer Pool & Performance Tuning

Optimizes MySQL 8: sizing innodb_buffer_pool_size, tuning innodb_redo_log_capacity, configuring innodb_io_capacity for NVMe SSDs, thread cache sizing, and query execution plan tuning.

## When to Invoke
Invoke this skill whenever you need to:
- tune mysql innodb buffer pool
- configure innodb redo log capacity
- optimize mysql for nvme

## Execution SOP & Rules
1. Allocate 60-75% of available system memory to innodb_buffer_pool_size on dedicated database nodes.
2. Set innodb_buffer_pool_instances = 8 to minimize mutex contention across multiple CPU threads.
3. Set innodb_redo_log_capacity to 4G-8G to smooth out write flushing during large batch transactions.
4. Verify buffer pool hit rate via SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_read%' targeting >99.5%.

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.