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
killer if you are inserting one row at a time. Check sync_binlogs, too. > -Original Message- > From: nixofortune [mailto:nixofort...@gmail.com] > Sent: Friday, June 28, 2013 1:29 AM > To: mysql list > Subject: mysql on zfs > > Hi guys, > Did you have any experienc

mysql on zfs

2013-06-28 Thread 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 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