| innodb_io_capacity | 后台刷脏 IOPS 目标，默认 200 |
|---|---|
| innodb_io_capacity_max | 紧急刷脏上限，默认 2 倍 |
| io_capacity | 要匹配实际盘的类型与共享情况 |
查看与调整
查看与调整
SHOW VARIABLES LIKE 'innodb_io_capacity%';
SET GLOBAL innodb_io_capacity = 2000;
SET GLOBAL innodb_io_capacity_max = 4000;
SHOW STATUS LIKE 'Innodb_buffer_pool_pages_dirty';同一块盘上还跑着 binlog、redo、备份任务时，io_capacity 越界会挤占正常读写；云盘看 IOPS 上限而不是盘名。