split_doublewrite for each write IO thread

Bug #690019 reported by Vadim Tkachenko
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Wishlist
Unassigned
5.5
Won't Fix
Wishlist
Unassigned
5.6
Won't Fix
Wishlist
Unassigned
5.7
Fix Released
Wishlist
Laurynas Biveinis

Bug Description

We discussed with Yasufumi so it may worth to try
split doublewrite area and perform IO into it in multiple IO threads.
currently it is done in single thread but in big size ( I observed 236K IO requests).

While it is good for HDD, it is bad for SSD and we need to experiment with it.

Changed in percona-server:
importance: Undecided → Wishlist
milestone: none → 5.5-20beta
status: New → Confirmed
description: updated
Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

I imagine "split into dedicated small buffers for each each IO threads" currently.
But each IO requests should be dispatched when requested. I need investigation for detail

Changed in percona-server:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

Basically, the doublewrite buffer is needed for SSD?

Changed in percona-server:
milestone: 5.5-20beta → none
Revision history for this message
Stewart Smith (stewart) wrote :

Leaving unassigned as unlikely to be on Yasufumi's short range TODO (more urgent things).

Changed in percona-server:
assignee: Yasufumi Kinoshita (yasufumi-kinoshita) → nobody
status: Confirmed → Triaged
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

This is going to be fixed by the parallel doublewrite feature. The fix slightly differs from the original description (work split not at I/O threads but at buffer pool flusher threads)

tags: added: innodb performance upstream
tags: added: xtradb
removed: innodb upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2338

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Related blueprints

Remote bug watches

Bug watches keep track of this bug in other bug trackers.