Re: [ceph-users] MySQL and ceph volumes

2017-03-08 Thread Matteo Dacrema
ites. >>> >>> Try enabling the sync option on fio and compare results. >>> >>> >>>> -Original Message- >>>> From: ceph-users [mailto:ceph-users-boun...@lists.ceph.com] On Behalf Of >>>> Matteo Dacrema >>>> Sen

Re: [ceph-users] MySQL and ceph volumes

2017-03-08 Thread Wido den Hollander
d compare results. > > > > > >> -Original Message- > >> From: ceph-users [mailto:ceph-users-boun...@lists.ceph.com] On Behalf Of > >> Matteo Dacrema > >> Sent: Wednesday, 8 March 2017 7:52 AM > >> To: ceph-users > >> S

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Christian Balzer
O from > the application, as it waits for the last write to complete before issuing > the next one. > > > From: Matteo Dacrema [mailto:mdacr...@enter.eu] > Sent: Wednesday, 8 March 2017 10:36 AM > To: Adrian Saul > Cc: ceph-users > Subject: Re: [ceph-users] MySQL and ceph volumes

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Adrian Saul
] Sent: Wednesday, 8 March 2017 10:36 AM To: Adrian Saul Cc: ceph-users Subject: Re: [ceph-users] MySQL and ceph volumes Thank you Adrian! I’ve forgot this option and I can reproduce the problem. Now, what could be the problem on ceph side with O_DSYNC writes? Regards Matteo

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Matteo Dacrema
sync option on fio and compare results. > > >> -Original Message- >> From: ceph-users [mailto:ceph-users-boun...@lists.ceph.com] On Behalf Of >> Matteo Dacrema >> Sent: Wednesday, 8 March 2017 7:52 AM >> To: ceph-users >> Subject: [ceph-users] MySQ

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Adrian Saul
day, 8 March 2017 7:52 AM > To: ceph-users > Subject: [ceph-users] MySQL and ceph volumes > > Hi All, > > I have a galera cluster running on openstack with data on ceph volumes > capped at 1500 iops for read and write ( 3000 total ). > I can’t understand why with fio

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Deepak Naidu
pth & see what’s your iostat looking, if it’s same then that’s what your disk can do. Now if you want to compare ceph RDB perf. Do the same on a normal block device. -- Deepak From: Matteo Dacrema [mailto:mdacr...@enter.eu] Sent: Tuesday, March 07, 2017 1:17 PM To: Deepak Naidu Cc: ceph-users

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Matteo Dacrema
on your FS block > size in KB & don’t just you the avgrq-sz # ] > > > -- > Deepak > > > > -Original Message- > From: ceph-users [mailto:ceph-users-boun...@lists.ceph.com > <mailto:ceph-users-boun...@lists.ceph.com>] On Behalf Of Matteo Dacrema > Sent:

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Deepak Naidu
h 07, 2017 12:52 PM To: ceph-users Subject: [ceph-users] MySQL and ceph volumes Hi All, I have a galera cluster running on openstack with data on ceph volumes capped at 1500 iops for read and write ( 3000 total ). I can’t understand why with fio I can reach 1500 iops without IOwait and MySQL