On 3/30/12 5:48 PM, Philip M. Gollucci wrote:
After reading several sparse articles/post, I've come to the conclusion
that FreeBSD doesn't do well with SWAP 32GB; however it does allow it.
As such I decided to drop the swap to 8GB*2=16GB. Sadly that didn't
help either after dropping
On 03/28/12 03:09, Philip M. Gollucci wrote:
It works out to roughly 7.7GB from 32MB okay fine.
If I double it, that should give me 15.4GB from 64MB (still not enough).
If I 16x it that should give me 246GB from 512MB. Thats more my
physical ram + swap. Oh well.
After reading several
On 03/27/12 02:32, Philip M. Gollucci wrote:
Some other tuning updates
$ zfs set zfs:zfs_nocacheflush = 1
$ sysctl vfs.zfs.prefetch_disable=1
$ cat /etc/my.cnf
skip-innodb-doublewrite
innodb_flush_log_at_trx_commit=2
$ zfs set primarycache=metadata zmysqlD
$ zfs set atime=off
/var/log/messages
Mar 23 22:21:50 sabertooth kernel: swap zone exhausted, increase
kern.maxswzone
Mar 23 22:21:50 sabertooth kernel: pid 86697 (mysqld), uid 88, was
killed: out of swap space
how to repeat:
$ mysql -ux file.sql (~150GB) worth
basically, it slows down continually until it dies.
Some other tuning updates
$ zfs set zfs:zfs_nocacheflush = 1
$ sysctl vfs.zfs.prefetch_disable=1
$ cat /etc/my.cnf
skip-innodb-doublewrite
innodb_flush_log_at_trx_commit=2
$ zfs set primarycache=metadata zmysqlD
$ zfs set atime=off zmysqlD
$ zfs set recordsize=16k zmysqlD
but not on zmysqlL