checkpoint及脏页

最新推荐文章于 2021-04-06 16:58:38 发布

clcj66885

最新推荐文章于 2021-04-06 16:58:38 发布

阅读量139

点赞数

文章标签：数据库

使用 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/