Minimizing restart time
§ InnoDB buffer pool may have a lot of unflushed data
So shutdown may take very long time
§ If you need to minimize downtime:
§ SET GLOBAL innodb_max_dirty_pages_pct=0
§ Watch Innodb_buffer_pool_pages_dirty in SHOW
STATUS
§ As it gets close to 0 shut down the server
§ During this operation performance will be lower as InnoDB
will be flushing dirty pages aggressively.
以后关闭msyql 先SET GLOBAL innodb_max_dirty_pages_pct=0 并观察
Innodb_buffer_pool_pages_dirty 当它的值接近0时,在关闭mysql 这个方法不错
阅读(1082) | 评论(0) | 转发(0) |