The process of Mysql submitting big SQL

1 SQL Commit, MySQL server first check the size of SQL by parameter max_allowed_packet , if exceeded, direct prompt MySQL go away.

2 server from the store will need to modify the data page load into memory (subject to innodb_buffer_pool_size).

3 Write the page and write redo undo log at the same time.

4 If SQL size exceeds the buffer setting (Innodb_log_file_size,innodb_log_files_in_group) of redo undo log, redo Undo log is written to disk.

Such changes can be observed through the parameter Innodb_log_waits (show global Status).

5 When commit occurs, the Undo/redo log is first committed to disk, and then the Dirty page is written to disk (and may still be cached in innodb_buffer_pool_size).

6 If the failure to complete the power outage, at this time before checkpoint data can be correctly guaranteed consistency and principle.

Cond

The process of Mysql submitting big SQL