Rick James <rjames@stripped> wrote:
>For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is
>optimal. (The default, 'cfq', is not as good.)
I should look into those again at some point. Do you have a brief word as to why they're
>A RAID controller with multiple drives striped (and optionally
>parity-checked) (RAID-5, -10) and with a BBU (Battery Backed Write
>Cache) is excellent for I/O.
Very true. 10 is traditionally considered better - it's certainly faster - but 5 is of
course cheaper :-)
I'd like to add that 4+1 is the optimal configuration for RAID5 , as that makes for a
stripe of 2kb, assuming 512b sectors of course. You then pick an fs that supports blocks
of that size , which means that no write will ever need to perform a read first to
calculate the checksum.
Sent from my Android phone with K-9 Mail. Please excuse my brevity.