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