percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00718
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