Re: [zfs-discuss] MySQL On ZFS Performance(fsync) Problem?

2009-04-16 Thread Richard Elling
简朝阳 wrote: Hi,all I did some test about MySQL's Insert performance on ZFS, and met a big performance problem,*i'm not sure what's the point*. Environment 2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel). A Java client run 8 threads concurrency insert into one Innodb table: *~600 qps

[zfs-discuss] MySQL On ZFS Performance(fsync) Problem?

2009-04-15 Thread 简朝阳
Hi,all I did some test about MySQL's Insert performance on ZFS, and met a big performance problem,*i'm not sure what's the point*. Environment 2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel). A Java client run 8 threads concurrency insert into one Innodb table: *~600 qps when

Re: [zfs-discuss] MySQL On ZFS Performance(fsync) Problem?

2009-04-15 Thread Kees Nuyt
On Wed, 15 Apr 2009 14:28:45 +0800, ?? sky...@gmail.com wrote: Hi,all I did some test about MySQL's Insert performance on ZFS, and met a big performance problem, *i'm not sure what's the point*. [snip performance and config info] Is there any one can help me, why fsync on zfs is so

Re: [zfs-discuss] MySQL On ZFS Performance(fsync) Problem?

2009-04-15 Thread Nicolas Williams
On Wed, Apr 15, 2009 at 07:39:13PM +0200, Kees Nuyt wrote: On Wed, 15 Apr 2009 14:28:45 +0800, ?? sky...@gmail.com wrote: I did some test about MySQL's Insert performance on ZFS, and met a big performance problem, *i'm not sure what's the point*. Q1: Did you set the filesystem's