It´s semi OT, but what about using XFS? Seems to be much better in terms of speed, not sure in terms of reliability: http://www.slideshare.net/ibsurgeon/firebird-25-benchmark-by-tsutomu-hayashi-tomneko
Regards! El 28/08/2011 07:14 p.m., Adriano dos Santos Fernandes escribió: > All, > > After I bought a new machine, I reinstalled Ubuntu in new HDD with ext4 > filesystem. > > While the new machine has much better CPU than the old one, I noticed > the build being very slow where Firebird was creating databases. > > I found that mounting the ext4 partition with barrier=0 parameter > decreased the performance from more than 2 minutes to less than 50s in > the build. > > But changing this parameter seems to not make ext4 at least safe as > ext3. So I reverted it and adjust the build to turn FW=off for the > internal databases. That didn't become fast as barrier=0, but was > acceptable (around 1 minute). > > Now I tried to run tcs and saw it's completely unpractical. So I started > to test just "create database" performance. > > The numbers are around this: > > ntfs: 0.2s > ext3 default (barrier=0): 0.1s > ext3 (barrier=1): 0.8s > ext4 default (barrier=1): 2.8s > > I removed the O_SYNC flag in posix.cpp and it makes ext4 similar to ext3. > > So I have some questions: > > Are we doing something wrong? > > Does ext4 just f*ks? > > Is ext3 good just until you need what it markets, i.e., you should pray > for no hardware crashes or power loss? > > What about some new parameter to ignore FW=on for who just don't care? > (tests, development, etc) > > > Adriano > > ------------------------------------------------------------------------------ > EMC VNX: the world's simplest storage, starting under $10K > The only unified storage solution that offers unified management > Up to 160% more powerful than alternatives and 25% more efficient. > Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > > -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbrug...@dasu.com.ar Website: www.dasu.com.ar ------------------------------------------------------------------------------ EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
