How to fix InnoDB dirty pages?

When I issue the command SHOW GLOBAL STATUS; MySQL, one of the lines that I get is the following:

Innodb_buffer_pool_pages_dirty  28

When I look at the documentation , all I see is:

The number of pages currently dirty. Added in MySQL 5.0.2.

How can I fix this (I assume dirty pages are not good)?

+5
source share
1 answer

- - . , MySQL , . , MySQL , . - , , .

MySQL flushesh , . , InnoDB - - - , , .

, innodb_max_dirty_pages_pct 0

+11
source

All Articles