MySQL Forums
Forum List  »  Performance

Re: InnoDB and separated disks
Posted by: Rick James
Date: January 29, 2011 06:14PM

My opinion...

Set up the entire set of drives as a single filesystem.
RAID the filesystem in whatever way you like. (RAID 10 is good.)
Since there is only one filesystem, all files (ibdata1, logs, .ibd, etc) are on the same filesystem.

The striping of the RAID (10, 5, etc) give you added performance. 8 drives in RAID-10 gives you about 8x the read performance and 4x the write perf.

Making separate filesystems on separate drives leads to
* One drive busy while the other is idle;
* Running out of space on one drive while the other one has lots of spare room;
* Needing to read or write on one filesystem before the other, thereby eliminating the benefit.

If you RAID is hardware, with a battery-backed write cache, you get these advantages:
* Writes are 'instantaneous' (unless you saturate the write cache);
* Power failure loses nothing.

Hardware RAID on Linux -- Set the "elevator strategy" to Noop. The default (CFQ?) has unnecessary overhead that is obviated by the RAID controller.

Options: ReplyQuote


Subject
Views
Written By
Posted
2415
January 28, 2011 04:34AM
Re: InnoDB and separated disks
936
January 29, 2011 06:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.