← Back to team overview

percona-discussion team mailing list archive

Re: Is there an advantage to moving doublewrite buffer to a separate file?

 

Mark,

We will do that, should not be that hard ( in part that does not touch
undo space reclamation).

Or you are also looking to be able to clean undo space ?

Thanks,
Vadim

On Thu, May 6, 2010 at 9:06 AM, MARK CALLAGHAN <mdcallag@xxxxxxxxx> wrote:
> We are interested in that work.
>
> On Thu, May 6, 2010 at 7:15 AM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>> Baron,
>>
>> This is to measure,  but I have task
>> https://blueprints.launchpad.net/percona-server/+spec/system-tablespace-control
>> to implement it for XtraDB
>>
>>
>> On Thu, May 6, 2010 at 4:12 AM, Baron Schwartz <baron@xxxxxxxxx> wrote:
>>> A few of the files in InnoDB get sequential writes.  The doublewrite
>>> buffer and log files are the primary places for sequential writes as I
>>> understand it.  The rest of ibdata1 and the .ibd files can get a lot
>>> of random writes, or at least partially random.
>>>
>>> Would a separate file for doublewrite buffer help?  Then it could be
>>> located on different storage.  How much does this matter?  Does it
>>> matter for durability?  Does it matter when placing some data on SSD
>>> and some on traditional hard drives?
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~percona-discussion
>>> Post to     : percona-discussion@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~percona-discussion
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>>
>> --
>> Vadim Tkachenko, CTO, Percona Inc.
>> Phone +1-888-401-3403,  Skype: vadimtk153
>> Schedule meeting: http://tungle.me/VadimTkachenko
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~percona-discussion
>> Post to     : percona-discussion@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~percona-discussion
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Mark Callaghan
> mdcallag@xxxxxxxxx
>



-- 
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-888-401-3403,  Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko



Follow ups

References