Re: Is the fsync() fake on FreeBSD6.1?

2006-07-02 Thread David Xu
On Tuesday 27 June 2006 11:34, Greg 'groggy' Lehey wrote: > This is not the case for Linux, where fsync syncs the entire file > system. That could explain some of the performance difference, but > not all of it. I suppose it's worth noting that, in general, people > report much better performanc

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-27 Thread Joseph Koshy
lh> Is the fsync() on FreeBSD6.1 fake? It doesn't appear to be: sys/kern/vfs_syscalls.c: 3194: fsync(td, uap) sys/ufs/ffs/ffs_vnops.c: 175: ffs_fsync(struct vop_fsync_args *ap) -- FreeBSD Volunteer, http://people.freebsd.org/~jkoshy ___ freebsd-pe

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-27 Thread Michael Vince
Greg 'groggy' Lehey wrote: On Tuesday, 27 June 2006 at 10:18:47 +0800, leo huang wrote: Hi, I benchmarked MySQL 4.1.18 on FreeBSD 6.1 and Debian 3.1 using Super Smack 1.3 some days ago. ... The result surprise me. The MySQL Performance on FreeBSD6.1 is about 10 times of on Debian3.1??and

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-27 Thread Leo Huang
hi, Arne, You could do this test: 1. write some data with dd if=/dev/zero of=/tmp/a bs=1m count=100 2. then fsync /tmp/a 3. then listen to the hard disc 4. repeat it until u r sure, if the hard disc reacts on the fsync command... :-) Good idea. But the room is noisy. I think I can not hear. :-

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-27 Thread R. B. Riddick
On Tuesday, 27 June 2006 at 10:18:47 +0800, leo huang wrote: > And how I can confirm this? > You could do this test: 1. write some data with dd if=/dev/zero of=/tmp/a bs=1m count=100 2. then fsync /tmp/a 3. then listen to the hard disc 4. repeat it until u r sure, if the hard disc reacts on the fs

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-27 Thread leo huang
Thanks Eric, Greg and Joseph. I will get more information from [EMAIL PROTECTED] 2006/6/27, Eric Anderson <[EMAIL PROTECTED]>: leo huang wrote: > Hi, > > I benchmarked MySQL 4.1.18 on FreeBSD 6.1 and Debian 3.1 using Super Smack > 1.3 some days ago. > > The benchmark table is > CREATE TABLE `A

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-26 Thread Greg 'groggy' Lehey
On Tuesday, 27 June 2006 at 10:18:47 +0800, leo huang wrote: > Hi, > > I benchmarked MySQL 4.1.18 on FreeBSD 6.1 and Debian 3.1 using Super Smack > 1.3 some days ago. > > ... > > The result surprise me. The MySQL Performance on FreeBSD6.1 is about > 10 times of on Debian3.1??and the output of iosta

Re: Is the fsync() fake on FreeBSD6.1?

2006-06-26 Thread Eric Anderson
leo huang wrote: Hi, I benchmarked MySQL 4.1.18 on FreeBSD 6.1 and Debian 3.1 using Super Smack 1.3 some days ago. The benchmark table is CREATE TABLE `Account` ( `aid` int(11) NOT NULL auto_increment, `name` char(20) NOT NULL default '', `flag` int(11) NOT NULL default '0', `uidcount` int

Is the fsync() fake on FreeBSD6.1?

2006-06-26 Thread leo huang
Hi, I benchmarked MySQL 4.1.18 on FreeBSD 6.1 and Debian 3.1 using Super Smack 1.3 some days ago. The benchmark table is CREATE TABLE `Account` ( `aid` int(11) NOT NULL auto_increment, `name` char(20) NOT NULL default '', `flag` int(11) NOT NULL default '0', `uidcount` int(11) NOT NULL defa

Is the fsync() fake on FreeBSD6.1?

2006-06-26 Thread leo huang
Hi, I benchmarked MySQL 4.1.18 on FreeBSD 6.1 and Debian 3.1 using Super Smack 1.3 some days ago. The benchmark table is CREATE TABLE `Account` ( `aid` int(11) NOT NULL auto_increment, `name` char(20) NOT NULL default '', `flag` int(11) NOT NULL default '0', `uidcount` int(11) NOT NULL defa