MariaDB on ZFS: Difference between revisions
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…“) |
No edit summary |
||
| 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 13:46, 21 October 2016
# 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
