mysql innodb master_thread伪代码整理

void master_thread()
{
int innodb_io_capacity = 200 ；//表示磁盘IO吞吐量
int innodb_max_dirty_pages_pct = 75 ；//最大脏页百分比
goto loop;
loop:
//1秒循环
for(int i = o; i<10; i++)
{
thread_sleep(1);//innodb 优化，压力大时不总是等待1秒
//日志缓冲刷新到磁盘
do log buffer flush to disk;
//如果磁盘压力小，合并插入缓冲
if ( last_one_second_ios < innodb_io_capacity*5%  )
{
do merge at most innodb_io_capacity*5% insert buffer;
}
//判断脏页比例
if ( buf_get_modified_ratio_pct > innodb_max_dirty_pages_pct )
{
do buffer pool flush innodb_io_capacity*100% dirty page;
}
//如果开启自适应刷新，通过判断产生重做日志的速度来判断合适的刷新脏页数量
else if enable adaptive flush
{
do buffer pool flush desired amount dirty page;
}
//如果无用户活动，切换到 backgroud loop
if ( no user activity )
{
goto backgroud loop;
}
}

//10秒循环
//如果磁盘压力小，刷新innodb_io_capacity*100%的脏页到磁盘
if ( last_ten_second_ios < innodb_io_capacity )
{
do buffer pool flush innodb_io_capacity*100% dirty page; 
}
//合并插入缓冲
do merge at most innodb_io_capacity*5% insert buffer;
//日志缓冲刷新到磁盘
do log buffer flush to disk;
//删除无用undo页，每次最多删除20个undo页
do full purge;
//判断脏页比例
if ( buf_get_modified_ratio_pct >70% )//---------
{
do buffer pool flush innodb_io_capacity*100% dirty page; 
}
else
{
do buffer pool flush innodb_io_capacity*10% dirty page;
}
//产生一个模糊检查点，只是将最老日志序列号的页写入磁盘
do fuzzy checkpoint;
goto loop;

//backgroud
backgroud loop:
//删除无用undo页
do full purge;
//合并插入缓冲
do merge innodb_io_capacity*100% insert buffer;
//不空闲跳回主循环，空闲则进入flush loop
if not idle
{
goto loop;
}
else
{
goto flush loop;
}

//flush loop
flush loop:
//不断刷新脏页到磁盘，直到脏页比例小于innodb_max_dirty_pages_pct，则进入suspend loop
do buffer pool flush innodb_io_capacity*100% dirty page;
    while ( buf_get_modified_ratio_pct > innodb_max_dirty_pages_pct );
goto suspend loop;

//suspend loop
suspend loop:
suspend_thread();
waiting event;
goto loop;
}