Shulou(Shulou.com)05/31 Report--

How to check the checkpoint and dirty pages, in view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a simpler and easier way.

Use show engine innodb status to view checkpoint points and dirty pages

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

This is the answer to the question about how to view checkpoint and dirty pages. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.