MySql服务优化之脏页

计算脏页比例

select VARIABLE_VALUE into @a from performance_schema.global_status where VARIABLE_NAME = 'Innodb_buffer_pool_pages_dirty';
select VARIABLE_VALUE into @b from performance_schema.global_status where VARIABLE_NAME = 'Innodb_buffer_pool_pages_total';
select @a/@b;

查看刷脏页能力

show global variables like 'innodb_io_capacity%';

进行设置刷脏页速度 innodb_io_capacity_max的50%~75%

set global innodb_io_capacity=400;