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

This article mainly explains "what is the role of innodb_fast_shutdown parameters in mysql". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the role of innodb_fast_shutdown parameters in mysql".

When mysql is turned off, the parameter innodb_fast_shutdown affects the behavior that the storage engine of the table is innodb. The parameter is 0, 1, 2, and 3 values.

0, which means that when MYSQL shuts down, Innodb needs to complete all full purge and merge insert buffer operations, which takes time to complete. If you do an Innodb plugin upgrade, you usually need to set this parameter to 0, and then shut down the database

1, which is the default value of the parameter, there is no need to complete full purge and merge insert buffer operations, but some dirty pages in the buffer pool will still be flushed to disk.

2 means that full purge and merge insert buffer operations do not need to be completed, and dirty pages of data in the buffer pool are not written back to disk. Instead, the logs are written to the log file. Nothing will be lost this way, but mysql will perform a restore operation (recovery) the next time it starts

If it was in the case of innodb_fast_shutdown=2 or mysql crash the last time innodb was closed, it uses redo log to redo transactions that have already been committed.

The next operation process is:

(1)。 Rollback uncompleted transitions cancels transactions that are not committed

(2)。 Purge all clears useless undo pages

(3)。 Merge insert buffer merge insert buffer

Thank you for your reading, the above is the content of "what is the role of innodb_fast_shutdown parameters in mysql". After the study of this article, I believe you have a deeper understanding of the role of innodb_fast_shutdown parameters in mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.