percona-discussion team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

We are interested in the ability to move the doublewrite buffer to a
separate file.

On Thu, May 6, 2010 at 1:45 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
> 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
>



-- 
Mark Callaghan
mdcallag@xxxxxxxxx