List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:June 28 2013 7:28pm
Subject:Re: mysql on zfs
View as plain text  

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
> backups.
> Your thought guys.
> Many thanks.
> Igor
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

Manuel Aróstegui
Systems Team
mysql on zfsnixofortune28 Jun
  • RE: mysql on zfsRick James28 Jun
  • Re: mysql on zfsManuel Arostegui28 Jun