使用 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
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博客 ” ，链接：https://blog.itpub.net/30127122/viewspace-2137900/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
innodb存储引擎存储结构
请登录后发表评论
登录
全部评论
