分类: 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 ] |
Always |
Always Not |
if [ modified_page_pct -gt
innodb_max_dirty_pages_pct ] |
if [ no user activity ] |
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 ] |
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 ] |
Flush Loop |
Always Not |
Always Not |
Always Not |
while [ modified_page_pct -gt
innodb_max_dirty_pages_pct ] |
goto [Suspend Loop] |
Suspend Loop |
Always Not |
Always Not |
Always Not |
Always Not |
if [ has new event ] |