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

This article introduces the knowledge of "what is the crash recovery process of mysql InnoDB". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Redo log operation: ensure that the latest data on the impact of committed transactions is brushed to the data page.

2. Undo log operation: ensure that the data pages affected by the uncommitted transaction are rolled back.

3. Write buffer (change buffer) merging.

4. Purge operation.

A garbage collection mechanism of InnoDB that uses separate background threads to periodically process data marked for deletion in an index.

Example

/ * Look for MLOG_CHECKPOINT. * / recv_group_scan_log_recs (group, & contiguous_lsn, false); / * The first scan should not have stored or applied any records. * / ut_ad (recv_sys- > n_addrs = = 0); ut_ad (! recv_sys- > found_corrupt_fs); if (recv_sys- > found_corrupt_log & &! srv_force_recovery) {log_mutex_exit (); return (DB_ERROR);} if (recv_sys- > mlog_checkpoint_lsn = = 0) {if (! srv_read_only_mode & & group- > scanned_lsn! = checkpoint_lsn) {ib::error ()

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.