Re: [ceph-users] MySQL and ceph volumes

2017-03-08 Thread Matteo Dacrema
Il giorno 08 mar 2017, alle ore 00:25, Adrian Saul >>> ha scritto: >>> >>> >>> Possibly MySQL is doing sync writes, where as your FIO could be doing >>> buffered writes. >>> >>> Try enabling the sync option on fio and compare result

Re: [ceph-users] MySQL and ceph volumes

2017-03-08 Thread Wido den Hollander
nal 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] MySQL and ceph volumes > >> > >&

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Christian Balzer
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 vo

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
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] MySQL and ceph volumes >> >>

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 I ca

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 Sub

Re: [ceph-users] MySQL and ceph volumes

2017-03-07 Thread Matteo Dacrema
B & 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: Tuesday, March 07, 2017

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

[ceph-users] MySQL and ceph volumes

2017-03-07 Thread Matteo Dacrema
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 can reach only 150 iops both read or writes showing 30% of IOwait. I tried with fi