Do you have trim enabled? Maybe those stalls could happen when the
disks are getting trimmed.
Just a random thought.
2013/6/28, nixofortune <nixofortune@stripped>:
> 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 840 SSD drives and experiencing temporary stalls.
> Our workload very much skewed towards inserts into big InnoDB tables
> (70-100Gig) the dataset overall 1.5T.
> I have feeling that ZFS is not mature enough to be used on production.
> The speed is not great either 2k-6k/s.
> I disabled innodb_checksums = 0 , innodb_doublewrite = 0 but the stalls
> up to 8min still there.
> Would it be better option to move to EXT4? We need FS snapshots for
> Your thought guys.
> Many thanks.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql