Skip to content

Decreasing shutdown time of MySQL with large transaction log file

If you need/have a large transaction log file, a shut down can take a while. This post lists how you can force a flush before you do so, decreasing shut down time.

In short:

mysql> set global innodb_max_dirty_pages_pct = 0;

Then monitor the dirty pages:

mysqladmin ext -i10 | grep dirty


    1 Comment ( Add comment / trackback )

    1. (permalink) Trackback from Adolor Uwamu
      On Nov 22, 2014 at 12:36

      Adolor Uwamu

      BigSmoke » Decreasing shutdown time of MySQL with large transaction log file