Best practices for ZFS setup for a strictly SSD based system?
Patrick M. Hausen
hausen at punkt.de
Tue Feb 9 17:05:25 UTC 2016
> Am 09.02.2016 um 17:32 schrieb Alan Somers <asomers at freebsd.org>:
>> * Will e.g. MySQL still profit from residing on a mirror
>> instead of a RAIDZ2, even if all disks are SSDs?
> Yes, because a mirrored vdev has as many read IOPs as all of its disks
> combined. So a RAID10 of SSDs will have many read IOPs indeed.
Ah … yes. Now I remember :)
> Will MySQL access its files in fixed-size records? If so, you can set
> the recsize filesystem property accordingly. If not, you should
> probably leave recsize at the default. If you profile MySQL's disk
> accesses and determine that there is a dominant recordsize, then go
> ahead and set ZFS's recsize to the next highest power of two.
> As usual, disable atime.
We already knew these. But thanks a lot for the vdev setup
hints! So it will be a mirror for OS and DB and a 4+2 raidz2
for the rest of the data.
Our MySQL zvols are currently set up like this:
InnoDB log files:
(rest inherited from above)
punkt.de GmbH * Kaiserallee 13a * 76133 Karlsruhe
Tel. 0721 9109 0 * Fax 0721 9109 100
info at punkt.de http://www.punkt.de
Gf: Jürgen Egeling AG Mannheim 108285
More information about the freebsd-stable