Innodb_fast_shutdown the difference between a value of 1 or 2?

Source: Internet
Author: User

Innodb_fast_shutdown=0, 1, 2 o'clock means

0

Brush the dirty pages in buffer pool to disk and merge insert buffer, including, of course, the redo log is also written to disk.

2

Just brush the redo log to disk and close

1

With regard to 1, it explains that it is a temporary skip over some flush operations, but does not specifically ignore which operations. Manual is not explained in detail,

The default shutdown procedure for InnoDB, based on the configuration setting innodb_fast_shutdown=1 . To save time, certain flush operations is skipped. This type of shutdown was safe during normal usage, because the flush operations is performed during the next startup, Usi Ng the same mechanism as in crash recovery. In cases where the database was being shut down for an upgrade or downgrade, does a slow shutdown instead to Ens Ure that all relevant changes is applied to the data files during the shutdown.

So I do not quite understand the difference between 2 and 1, in order to find the answer, can only look at the code. And finally found this function

Buf_flush_page_cleaner_thread, which describes the subtle differences in the interior. I didn't see it because it involved a concrete implementation.

Well, there's time to see it again.

Innodb_fast_shutdown the difference between a value of 1 or 2?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.