标签：之脏页 into global innodb io MySql VARIABLE 优化 select
计算脏页比例
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;
标签：之脏页,
into,
global,
innodb,
io,
MySql,
VARIABLE,
优化,
select
From： https://www.cnblogs.com/vaen/p/16856386.html