Mobile - Settings - Register - Help

Home

Quick jump: What's new - Weblogs

Print
Tools

V

4

Tags

{"maxCount":21,"tags":[{"page_count":21,"count":null,"name":"hardware"},{"page_count":18,"count":null,"name":"Welcome"},{"page_count":17,"count":null,"name":"howto"},{"page_count":12,"count":null,"name":"FPGA"},{"page_count":9,"count":null,"name":"arm"},{"page_count":8,"count":null,"name":"OpenVZ"},{"page_count":7,"count":null,"name":"projects"},{"page_count":7,"count":null,"name":"virtualization"},{"page_count":7,"count":null,"name":"linux"},{"page_count":6,"count":null,"name":"air quality"},{"page_count":5,"count":null,"name":"SocialText"},{"page_count":5,"count":null,"name":"Android"},{"page_count":5,"count":null,"name":"STM32"},{"page_count":4,"count":null,"name":"Arduino"},{"page_count":4,"count":null,"name":"RFID"},{"page_count":3,"count":null,"name":"RaspberryPi"},{"page_count":3,"count":null,"name":"home-assistant"},{"page_count":3,"count":null,"name":"ADSL"},{"page_count":3,"count":null,"name":"Jifty"},{"page_count":3,"count":null,"name":"openmoko"},{"page_count":3,"count":null,"name":"KVM"},{"page_count":2,"count":null,"name":"razmjenavjestina"},{"page_count":2,"count":null,"name":"NoSQL"},{"page_count":2,"count":null,"name":"gsm"},{"page_count":2,"count":null,"name":"WebGUI"},{"page_count":2,"count":null,"name":"security"},{"page_count":2,"count":null,"name":"QEMU"},{"page_count":2,"count":null,"name":"usb"},{"page_count":2,"count":null,"name":"svn"},{"page_count":2,"count":null,"name":"433 MHz"},{"page_count":2,"count":null,"name":"eeepc"},{"page_count":2,"count":null,"name":"STM8"},{"page_count":2,"count":null,"name":"VoIP"},{"page_count":2,"count":null,"name":"perl"},{"page_count":2,"count":null,"name":"PowerPC"},{"page_count":2,"count":null,"name":"usb-tester"},{"page_count":2,"count":null,"name":"RF"},{"page_count":2,"count":null,"name":"php"},{"page_count":2,"count":null,"name":"motion sensor"},{"page_count":2,"count":null,"name":"esp8285"},{"page_count":2,"count":null,"name":"DVB"},{"page_count":2,"count":null,"name":"TV"},{"page_count":2,"count":null,"name":"PostgreSQL"},{"page_count":2,"count":null,"name":"PIC"},{"page_count":2,"count":null,"name":"asterisk"},{"page_count":1,"count":null,"name":"nslu2"},{"page_count":1,"count":null,"name":"javascript"},{"page_count":1,"count":null,"name":"PIC16F684"},{"page_count":1,"count":null,"name":"Email"},{"page_count":1,"count":null,"name":"8051"},{"page_count":1,"count":null,"name":"A10"},{"page_count":1,"count":null,"name":"csv"},{"page_count":1,"count":null,"name":"ppc"},{"page_count":1,"count":null,"name":"video"},{"page_count":1,"count":null,"name":"Kindle"},{"page_count":1,"count":null,"name":"Ubuntu"},{"page_count":1,"count":null,"name":"wiki"},{"page_count":1,"count":null,"name":"bluetooth"},{"page_count":1,"count":null,"name":"css"},{"page_count":1,"count":null,"name":"sdr"},{"page_count":1,"count":null,"name":"printer"},{"page_count":1,"count":null,"name":"https"},{"page_count":1,"count":null,"name":"Bioinformatics"},{"page_count":1,"count":null,"name":"Dell"},{"page_count":1,"count":null,"name":"subversion"},{"page_count":1,"count":null,"name":"MSP430"},{"page_count":1,"count":null,"name":"icecast"},{"page_count":1,"count":null,"name":"Cisco"},{"page_count":1,"count":null,"name":"PPPoE"},{"page_count":1,"count":null,"name":"vpn"},{"page_count":1,"count":null,"name":"eeprom"},{"page_count":1,"count":null,"name":"GXemul"},{"page_count":1,"count":null,"name":"Seaside"},{"page_count":1,"count":null,"name":"http"},{"page_count":1,"count":null,"name":"kde"},{"page_count":1,"count":null,"name":"CARNet"},{"page_count":1,"count":null,"name":"hid"},{"page_count":1,"count":null,"name":"darkice"},{"page_count":1,"count":null,"name":"gearman"},{"page_count":1,"count":null,"name":"Baze podataka"},{"page_count":1,"count":null,"name":"iBook"},{"page_count":1,"count":null,"name":"mash"},{"page_count":1,"count":null,"name":"IR"},{"page_count":1,"count":null,"name":"olsr"},{"page_count":1,"count":null,"name":"wifi"},{"page_count":1,"count":null,"name":"ogg"},{"page_count":1,"count":null,"name":"esp8266"},{"page_count":1,"count":null,"name":"fbtft"},{"page_count":1,"count":null,"name":"FreeBSD"},{"page_count":1,"count":null,"name":"Smalltalk"},{"page_count":1,"count":null,"name":"A20"},{"page_count":1,"count":null,"name":"sysadmin"},{"page_count":1,"count":null,"name":"streaming"},{"page_count":1,"count":null,"name":"bcm968xx"},{"page_count":1,"count":null,"name":"git"},{"page_count":1,"count":null,"name":"svn2cvs"},{"page_count":1,"count":null,"name":"rk3066"},{"page_count":1,"count":null,"name":"shell"},{"page_count":1,"count":null,"name":"debian"},{"page_count":1,"count":null,"name":"ups"},{"page_count":1,"count":null,"name":"ssl"},{"page_count":1,"count":null,"name":"Apple"},{"page_count":1,"count":null,"name":"3M"},{"page_count":1,"count":null,"name":"mysql"},{"page_count":1,"count":null,"name":"Announcements"},{"page_count":0,"count":null,"name":"bljak"},{"page_count":0,"count":null,"name":"HTC"}]}

There are no tags for this page.

Incoming Links

There are no pages that link to this page yet.

Attachments

Dobrica Pavlinušić's random unstructured stuff

ZFS

Contents

ZFS

MySQL

cache only metadata for Innodb
match recordsize to block size

root filesystem on zfs

ZFS

MySQL

cache only metadata for Innodb

zfs set primarycache=metadata tank/db

match recordsize to block size

before creating database

zfs set recordsize=16k tank/db

root filesystem on zfs

based on https://github.com/zfsonlinux/zfs/wiki/HOWTO-install-Debian-GNU-Linux-to-a-Native-ZFS-Root-Filesystem

root@lib10:~# apt-get install zfs-initramfs

root@lib10:~# zfs create -o mountpoint=none lib10/ROOT

root@lib10:~# zfs create -o mountpoint=/ lib10/ROOT/debian-1
cannot mount '/': directory is not empty
filesystem successfully created, but not mounted

root@lib10:~# zpool set bootfs=lib10/ROOT/debian-1 lib10

root@lib10:~# mkdir /tmp/root
root@lib10:~# mount --bind / /tmp/root/

root@lib10:~# mkdir /tmp/zfs-root
root@lib10:~# zfs set mountpoint=/tmp/zfs-root lib10/ROOT/debian-1
root@lib10:~# zfs mount lib10/ROOT/debian-1
root@lib10:~# zfs set compression=lz4 lib10/ROOT
root@lib10:~# rsync -ravH --numeric-ids /tmp/root/ /tmp/zfs-root/

# duh, source btrfs had snapshot on it

root@lib10:~# rsync -ravH --numeric-ids --exclude '/.snapshot' --exclude '/tmp' --delete /tmp/root/ /tmp/zfs-root/

root@lib10:~# zfs umount lib10/ROOT/debian-1

root@lib10:~# cd /tmp/zfs-root/

root@lib10:~# cd /tmp/zfs-root/
root@lib10:/tmp/zfs-root# mount --bind /dev dev/
root@lib10:/tmp/zfs-root# mount --bind /sys sys/
root@lib10:/tmp/zfs-root# mount --bind /proc/ proc/
root@lib10:/tmp/zfs-root# chroot .
root@lib10:/# 

root@lib10:~# df
Filesystem          1K-blocks    Used Available Use% Mounted on
lib10/ROOT/debian-1 195788544 1149184 194639360   1% /
udev                 10270376       0  10270376   0% /dev
root@lib10:~# mount /boot/
root@lib10:~# df
Filesystem          1K-blocks    Used Available Use% Mounted on
lib10/ROOT/debian-1 195787904 1149184 194638720   1% /
udev                 10270376       0  10270376   0% /dev
/dev/sdg1              198337   62072    136265  32% /boot

root@lib10:~# grep zfs /etc/default/grub 
GRUB_CMDLINE_LINUX_DEFAULT="boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1"

root@lib10:~# update-grub

root@lib10:~# grep zfs /boot/grub/grub.cfg 
insmod zfs
        linux   /vmlinuz-4.8.0-2-amd64 root=ZFS=lib10/ROOT/debian-1 ro  boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1
                linux   /vmlinuz-4.8.0-2-amd64 root=ZFS=lib10/ROOT/debian-1 ro  boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1
                linux   /vmlinuz-4.8.0-1-amd64 root=ZFS=lib10/ROOT/debian-1 ro  boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1


root@lib10:~# update-initramfs -v -k all -u

root@lib10:~# umount /boot/
root@lib10:~# exit


root@lib10:~# umount /tmp/zfs-root/dev/
root@lib10:~# umount /tmp/zfs-root/proc/
root@lib10:~# umount /tmp/zfs-root/sys/

root@lib10:~# zfs umount lib10/ROOT/debian-1

root@lib10:~# zfs set mountpoint=/ lib10/ROOT/debian-1

Upload Files

Click "Browse" to find the file you want to upload. When you click "Upload file" your file will be uploaded and added to the list of attachments for this page.

Maximum file size: 50MB

Add a link to the attachment at the top of the page? Images will appear in the page.

Expand zip archive and attach individual files to the page

Done

	File Name	Author	Date Uploaded	Size

Close

Delete Selected Files

Upload Files

Click "Browse" to find the file you want to upload. When you click "Add file" this file will be added to the list of attachments for this page, and uploaded when you save the page.

Add a link to the attachment at the top of the page? Images will appear in the page when the page is saved.

Expand zip archive and attach individual files to the page

Done

Add file

Add Tags

Enter a tag and click "Add tag". The tag will be saved when you save the page.

Tag:

Suggestions:

Done

Add tag

{toc: }

^ ZFS

^^ MySQL

* http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121
* http://assets.en.oreilly.com/1/event/21/Optimizing%20MySQL%20Performance%20with%20ZFS%20Presentation.pdf
* http://www.youtube.com/watch?v=a31NhwzlAxs

^^^ cache only metadata for Innodb

.pre
zfs set primarycache=metadata tank/db
.pre

^^^ match recordsize to block size

before creating database

.pre
zfs set recordsize=16k tank/db
.pre

^ root filesystem on zfs

based on https://github.com/zfsonlinux/zfs/wiki/HOWTO-install-Debian-GNU-Linux-to-a-Native-ZFS-Root-Filesystem

.pre
root@lib10:~# apt-get install zfs-initramfs

root@lib10:~# zfs create -o mountpoint=none lib10/ROOT

root@lib10:~# zfs create -o mountpoint=/ lib10/ROOT/debian-1
cannot mount '/': directory is not empty
filesystem successfully created, but not mounted

root@lib10:~# zpool set bootfs=lib10/ROOT/debian-1 lib10

root@lib10:~# mkdir /tmp/root
root@lib10:~# mount --bind / /tmp/root/

root@lib10:~# mkdir /tmp/zfs-root
root@lib10:~# zfs set mountpoint=/tmp/zfs-root lib10/ROOT/debian-1
root@lib10:~# zfs mount lib10/ROOT/debian-1
root@lib10:~# zfs set compression=lz4 lib10/ROOT
root@lib10:~# rsync -ravH --numeric-ids /tmp/root/ /tmp/zfs-root/

# duh, source btrfs had snapshot on it

root@lib10:~# rsync -ravH --numeric-ids --exclude '/.snapshot' --exclude '/tmp' --delete /tmp/root/ /tmp/zfs-root/

root@lib10:~# zfs umount lib10/ROOT/debian-1

root@lib10:~# cd /tmp/zfs-root/

root@lib10:~# cd /tmp/zfs-root/
root@lib10:/tmp/zfs-root# mount --bind /dev dev/
root@lib10:/tmp/zfs-root# mount --bind /sys sys/
root@lib10:/tmp/zfs-root# mount --bind /proc/ proc/
root@lib10:/tmp/zfs-root# chroot .
root@lib10:/#

root@lib10:~# df
Filesystem          1K-blocks    Used Available Use% Mounted on
lib10/ROOT/debian-1 195788544 1149184 194639360   1% /
udev                 10270376       0  10270376   0% /dev
root@lib10:~# mount /boot/
root@lib10:~# df
Filesystem          1K-blocks    Used Available Use% Mounted on
lib10/ROOT/debian-1 195787904 1149184 194638720   1% /
udev                 10270376       0  10270376   0% /dev
/dev/sdg1              198337   62072    136265  32% /boot

root@lib10:~# grep zfs /etc/default/grub 
GRUB_CMDLINE_LINUX_DEFAULT="boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1"

root@lib10:~# update-grub

root@lib10:~# grep zfs /boot/grub/grub.cfg 
insmod zfs
        linux   /vmlinuz-4.8.0-2-amd64 root=ZFS=lib10/ROOT/debian-1 ro  boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1
                linux   /vmlinuz-4.8.0-2-amd64 root=ZFS=lib10/ROOT/debian-1 ro  boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1
                linux   /vmlinuz-4.8.0-1-amd64 root=ZFS=lib10/ROOT/debian-1 ro  boot=zfs rpool=lib10 bootfs=lib10/ROOT/debian-1

root@lib10:~# update-initramfs -v -k all -u

root@lib10:~# umount /boot/
root@lib10:~# exit

root@lib10:~# umount /tmp/zfs-root/dev/
root@lib10:~# umount /tmp/zfs-root/proc/
root@lib10:~# umount /tmp/zfs-root/sys/

root@lib10:~# zfs umount lib10/ROOT/debian-1

root@lib10:~# zfs set mountpoint=/ lib10/ROOT/debian-1

.pre