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 kern.maxsw
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 sp
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 atim
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
m
/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.