… is aproximately correct. The data is modified directly in the buffer pool pages, which becomes “dirty” if there are some unflushed changes… one more “physical” log file which is called “double write buffer” to handle problem of partial page writes. The log file….com/2006/05/19/group-commit-and-xa/ – disabling XA saves you from extra fsync which allows to double results but…
Comment: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… prototype of remembering the buffer pool on shutdown had potential, and was relatively simple. In a nutshell, he merely saved a list of…
Comment: Innodb Performance Optimization Basics
March 30, 2009 By 75 Comments
… (increasing at the rate of ~200mb/day). We need to save complete documents in the system so basically one column has… 8M. All tables except one are INNO DB and its buffer pool size is 1024M. The end user client module is read…
Comment: MySQL random freezes could be the query cache
March 27, 2009 By 23 Comments
… (increasing at the rate of ~200mb/day). We need to save complete documents in the system so basically one column has… 8M. All tables except one are INNO DB and its buffer pool size is 1024M. The end user client module is read…
