percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00717
Re: Is there an advantage to moving doublewrite buffer to a separate file?
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
Follow ups
References