checkpoint及脏页

使用 show engine innodb status 可以查看checkpoint 点及脏页情况

Log sequence number 173 2375496585
Log flushed up to   173 2375496585
Last checkpoint at  173 2284696373
0 pending log writes, 0 pending chkp writes
2823087 log i/o's done, 8.48 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 9375578472; in additional pool allocated 20971520
Dictionary memory allocated 5379456
Buffer pool size   518144
Free buffers       0
Database pages     475396
Modified db pages  9647


详情 请参考 http://blog.sina.com.cn/s/blog_4d8a2c970100f53u.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30127122/viewspace-2137900/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30127122/viewspace-2137900/