percona-discussion team mailing list archive

[Baron Schwartz <baron@xxxxxxxxx>]

I see.  That looks good and useful.

- Baron

On Thu, May 6, 2010 at 10: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
>



-- 
Baron Schwartz
Percona Inc <http://www.percona.com/>
Consulting, Training, Support & Services for MySQL