Parameters that affect MySQL shutdown innodb_fast_shutdown

in the closeMySQLwhen the parameterInnodb_fast_shutdown willaffects the storage engine asInnodbthe behavior of the table. The value of this parameter is {0,1,2}. Parameter value is 0RepresentativeMySQLwhen off,InnoDBneed to complete all theFull purgeand theMergeinsert Bufferoperation, this process will take a certain amount of time, and sometimes it may take several hours. In doingInnoDB Pluginwhen upgrading, it is common to say that this parameter is adjusted to0, and then close the database. Parameter value is1is the default value for this parameter, which means closeMySQLWhen not completedFullpurgeand theMerge Insert Buffer, but the dirty pages in the buffer pool are still written to disk. Parameter value is2indicates that neither completeFullpurgeand theMerge Insert Buffer, and the dirty pages in the buffer pool are not flushed to disk, but the logs are written to the log file. In this case, the transaction is not lost, but the next time you startMySQLinstance recovery is performed.

This article is from "Master Wang" blog, please be sure to keep this source http://johnnywong.blog.51cto.com/1997751/1660729

Parameters that affect MySQL shutdown innodb_fast_shutdown