Chinaunix首页 | 论坛 | 博客
  • 博客访问: 34697
  • 博文数量: 8
  • 博客积分: 46
  • 博客等级: 民兵
  • 技术积分: 90
  • 用 户 组: 普通用户
  • 注册时间: 2011-09-06 14:26
个人简介

干过研发,弄过运维,现在专职DBA。 玩过MYSQL,看过MARIADB,目前在搞MongoDB.

文章分类

全部博文(8)

文章存档

2013年(8)

我的朋友

分类: Mysql/postgreSQL

2013-11-18 17:45:01



 

Change Buffer

Redo Log Buffer

Undo Log

Modified Page

Next Loop

Loop /second

if [ last_one_second_ios -lt 5% innodb_io_capacity ]
then
         merge 5% innodb_io_capacity change buffer;
fi

Always

Always Not

if [ modified_page_pct -gt innodb_max_dirty_pages_pct ]
then
        flush 100% innodb_io_capacity modified page;
else
        innodb_adaptive_flushing modified page;
fi

if [ no user activity ]
then
    goto [Background Loop];
fi

Loop /10 seconds

 merge 5% innodb_io_capacity change buffer;

Always

purge 100% purge_batch_size undo log

if [ last_ten_second_ios -lt 100% innodb_io_capacity ]
then
         flush 100% innodb_io_capacity modified page;
fi
if [ modified_page_pct -gt 70% ]
then
        flush 100% innodb_io_capacity modified page;
else
         flush 10% innodb_io_capacity modified page;
fi

goto [Loop / second]

Background Loop

 merge 100% innodb_io_capacity change buffer;

Always Not

purge 100% purge_batch_size undo log

Always Not

if [ not idle ]
then
    goto [Loop / second];
else
    goto [Flush Loop];
fi

Flush Loop

Always Not

Always Not

Always Not

while [ modified_page_pct -gt innodb_max_dirty_pages_pct ]
do
        flush 100% innodb_io_capacity modified page;
done

goto [Suspend Loop]

Suspend Loop

Always Not

Always Not

Always Not

Always Not

if [ has new event ]
then
    goto [Loop / second];
fi

阅读(611) | 评论(0) | 转发(0) |
0

上一篇:MySQL子查询(in)与关联查询(join)区别

下一篇:没有了

给主人留下些什么吧!~~