MySQL Bugs: #75031: Request to port reduced doublewrite patch from WebScaleSQL

Bug #75031	Request to port reduced doublewrite patch from WebScaleSQL
Submitted:	28 Nov 2014 2:41
Reporter:	Yoshinori Matsunobu (OCA)	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	5.6	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
We know that doublewrite causes lots of performance and write-cycle problems on flash/SSDs. WebScaleSQL has a patch to add "reduced doublewrite" mode, which writes only page ids, not whole data. This is useful to "detect" torn page problems. Since torn page problems don't happen so often in real environments, detecting is good enough, and half (less than half when using compression) write volume is definitely helpful.

Patch is here.
https://github.com/webscalesql/webscalesql-5.6/commit/cdbce698e470c0081ebad9770e4b0010ca5b...

How to repeat:
N/A

Suggested fix:
Port the patch