Difference between revisions of "MariaDB on ZFS"

From Lolly's Wiki
Jump to navigationJump to search
(Die Seite wurde neu angelegt: „ <source lang=bash> # zfs list -o recordsize,primarycache,compression,compressratio,atime,name -r MYSQL-DATA -r MYSQL-LOG RECSIZE PRIMARYCACHE COMPRESS RATI…“)
 
Line 1: Line 1:
 
+
[[Kategorie: MySQL|ZFS]]
 +
[[Kategorie: MariaDB|ZFS]]
 
<source lang=bash>
 
<source lang=bash>
 
# zfs list -o recordsize,primarycache,compression,compressratio,atime,name -r MYSQL-DATA -r MYSQL-LOG
 
# zfs list -o recordsize,primarycache,compression,compressratio,atime,name -r MYSQL-DATA -r MYSQL-LOG

Revision as of 14:46, 21 October 2016

ZFS ZFS

# zfs list -o recordsize,primarycache,compression,compressratio,atime,name -r MYSQL-DATA -r MYSQL-LOG
RECSIZE  PRIMARYCACHE  COMPRESS  RATIO  ATIME  NAME
   128K           all       lz4  1.06x    off  MYSQL-DATA
    16K      metadata       lz4  2.81x    off  MYSQL-DATA/InnoDB
     8K           all       lz4  1.05x    off  MYSQL-DATA/data
   128K           all       lz4  2.15x    off  MYSQL-LOG
   128K           all       lz4  1.00x    off  MYSQL-LOG/binlog
   128K      metadata       lz4  2.17x    off  MYSQL-LOG/ib_log
datadir                         = /MYSQL-DATA/data/mysql
innodb_data_home_dir            = /MYSQL-DATA/InnoDB
innodb_data_file_path           = ibdata1:2000M:autoextend
innodb_log_group_home_dir       = /MYSQL-LOG/ib_log
innodb_flush_method             = O_DIRECT
innodb_flush_log_at_trx_commit  = 2
skip-innodb_doublewrite