Note from MySQL on ZFS - Performance

Create ZFS storage pools

Create a new zfs pool called “container-pool” on /dev/sdX. The ZFS Zpool will also be called “container-pool”.

$ lxc storage create container-pool zfs source=zfs/container-pool
$ zfs set quota=336g zfs/container-pool  ### absolute total for the whole pool

create storage volume to pool

$ lxc storage volume create container-pool mysql-volume
$ zfs set recordsize=16k zfs/container-pool/custom/zfs_mysql-volume

init container to pool

$ lxc init ubuntu:20.04 container-name -s container-pool

config device to container

$ lxc config device add container-name mysql-disk disk pool=container-pool source=mysql-volume path=/var/lib/mysql

start container

$ lxc start container-name

Querying ZFS Properties

You can use the special keyword all to retrieve all dataset property values.

# show zfs pool
zpool list 
NAME      SIZE  ALLOC   FREE  CKPOINT  EXPANDSZ   FRAG    CAP  DEDUP    HEALTH  ALTROOT
default   186G  21.5G   165G        -         -     5%    11%  1.00x    ONLINE  -

# get properties of default pool
zfs get all default
NAME     PROPERTY              VALUE                  SOURCE
default  type                  filesystem             -
default  creation              Sun Sep  5  0:00 2021  -
default  used                  21.5G                  -
default  available             159G                   -
default  referenced            24K                    -
default  compressratio         2.37x                  -

• default :