Re: [ceph-users] Mysql performance on CephFS vs RBD

2017-05-01 Thread RDS
There is 1 more thing that I noticed when using cephfs instead of RBD for MySQL, and that is CPU usage on the client. When using RBD, I was using 99% of the CPU’s. When I switched to cephfs, the same tests were using 60% of the CPU. Performance was about equal. This test was an OLTP sysbench usi

Re: [ceph-users] Mysql performance on CephFS vs RBD

2017-05-01 Thread Gregory Farnum
On Mon, May 1, 2017 at 9:17 AM, Babu Shanmugam wrote: > > My intention is to just identify the root cause for the too much time spent > on a "table create" operation on CephFS. I am *not* trying to benchmark with > my testing. Sorry if it wasn't clear in my mail. > > I am sure the time spent wou

Re: [ceph-users] Mysql performance on CephFS vs RBD

2017-05-01 Thread Babu Shanmugam
My intention is to just identify the root cause for the too much time spent on a "table create" operation on CephFS. I am *not* trying to benchmark with my testing. Sorry if it wasn't clear in my mail. I am sure the time spent would be lesser if I had a proper CEPH setup. But, I believe even t

Re: [ceph-users] Mysql performance on CephFS vs RBD

2017-05-01 Thread Scottix
I'm by no means a Ceph expert but I feel this is not a fair representation of Ceph, I am not saying numbers would be better or worse. Just the fact I see some major holes that don't represent a typical Ceph setup. 1 Mon? Most have a minimum of 3 1 OSD? basically all your reads and writes are going

Re: [ceph-users] Mysql performance on CephFS vs RBD

2017-04-30 Thread Babu Shanmugam
On Monday 01 May 2017 10:24 AM, David Turner wrote: You don't have results that include the added network latency of having replica 3 replicating across multiple hosts. The reads would be very similar as the primary is the only thing that is read from, but writes will not return until after

Re: [ceph-users] Mysql performance on CephFS vs RBD

2017-04-30 Thread David Turner
You don't have results that include the added network latency of having replica 3 replicating across multiple hosts. The reads would be very similar as the primary is the only thing that is read from, but writes will not return until after all 3 copies are written. On Sat, Apr 29, 2017, 9:46 PM Ba

[ceph-users] Mysql performance on CephFS vs RBD

2017-04-29 Thread Babu Shanmugam
Hi, I did some basic experiments with mysql and measured the time taken by a set of operations on CephFS and RBD. The RBD measurements are taken on a 1GB RBD disk with ext4 filesystem. Following are my observation. The time listed below are in seconds. *Plain file system* *CephFS