Re: mysql on zfs

2013-06-28 Thread Manuel Arostegui
Hello, Do you have trim enabled? Maybe those stalls could happen when the disks are getting trimmed. Just a random thought. Manuel 2013/6/28, nixofortune : > Hi guys, > Did you have any experience running MyLSQ or in my case MariaDB 5.5.31 > on FreeBSD on top of zfs? > We are using Samsung Pro 8

RE: mysql on zfs

2013-06-28 Thread Rick James
Prefer xfs on RHEL. Certain stalls are inherent in older InnoDBs, but MariaDB 5.5 should have the Percona fixes that greatly smoothed out that problem. What kind of drives? A RAID controller with caching helps for datasets that big. innodb_flush_log_at_trx_commit = 1 is a big performance kill