while (srv_shutdown_state == SRV_SHUTDOWN_NONE) {
//1 server active或者有挂起的读IO请求或者n_flushed==0
// sleep 1微妙
if (srv_check_activity(last_activity)
|| buf_get_n_pending_read_ios()
|| n_flushed == 0) {
page_cleaner_sleep_if_needed(next_loop_time);
}
//2
next_loop_time = ut_time_ms() + 1000;
if (srv_check_activity(last_activity)) {
last_activity = srv_get_activity_count();
//2.1
n_flushed = buf_flush_LRU_tail();
//2.2
n_flushed += page_cleaner_flush_pages_if_needed();
}else{
n_flushed = page_cleaner_do_flush_batch(PCT_IO(100),LSN_MAX);
//刷srv_io_capacity个即200个page
//page_cleaner_do_flush_batch->buf_f
buf_flush_page_cleaner_thread
最新推荐文章于 2023-07-09 08:22:49 发布
本文介绍了InnoDB存储引擎中Page Cleaner线程的工作机制,包括buf_flush_LRU_tail和buf_flush_batch过程,这两个过程分别按比例和固定数量清理页面。还讨论了可能存在的热点数据替换问题,并提到了page_cleaner_flush_pages_if_needed在自动调整刷脏页数量上的作用。
摘要由CSDN通过智能技术生成