InnoDB data off the disk

MySQL's InnoDB storage engine data refresh every situation. This post from InnoDB down, look at the data from the memory to the InnoDB actually written on the media storage device in the end there is a buffer in which to work. We look through the following figure at the relevant buffer: From the figure above, we can see that the InnoDB data to disk need to go through InnoDB buffer pool, Redo log buffer. This is a buffer InnoDB application itself. page cache / Buffer cache (can be bypassed by o_direct). This is a buffer vfs layer. Inode cache / directory buffer. This is the buffer vfs layer. Need to refresh by O_SYNC or fsync (). Write-Back buffer. (You can set parameters to bypass the memory controller) Disk on-borad buffer. (Can be bypassed by setting the disk controller parameters) Here we use the term "buffer" (typically buffer) to represent the data write scratch, using the term "cache" (usually cache) to represent the data re