Bruce Momjian wrote:
InnoDB uses a doublebuffer system instead.Our current WAL implementation writes copies of full pages to WAL before modifying the page on disk. This is done to prevent partial pages from being corrupted in case the operating system crashes during a page write. http://www.innodb.com/ibman.php#File.space.management quote: Starting from 3.23.40b, InnoDB uses a novel file flush technique
called Doublewrite means that InnoDB before writing pages to a data file first writes them to a contiguous tablespace area called the doublewrite buffer. Only after the write and the flush to the doublewrite buffer has completed, InnoDB writes the pages to their proper positions in the data file. If the operating system crashes in the middle of a page write, InnoDB will in recovery find a good copy of the page from the doublewrite buffer. -- Dennis |
- Re: [HACKERS] WAL write of full pages Manfred Spraul
- Re: [HACKERS] WAL write of full pages Shridhar Daithankar
- Re: [HACKERS] WAL write of full pages Bruce Momjian
- [HACKERS] Some one deleted pg_database en... Dave Cramer
- Re: [HACKERS] Some one deleted pg_dat... Tom Lane
- Re: [HACKERS] Some one deleted pg... Dave Cramer
- Re: [HACKERS] Some one delet... Tom Lane
- Re: [HACKERS] Some one d... Tom Lane
- Re: [HACKERS] Some one delet... Robert Treat
- Re: [HACKERS] Some one delet... Christopher Kings-Lynne
- Re: [HACKERS] WAL write of full pages Dennis Haney
- Re: [HACKERS] WAL write of full pages Bruce Momjian