← Back to team overview

percona-discussion team mailing list archive

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

 

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



Follow ups

References