Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Alexander Peshkov
В Пн., 29/08/2011 в 13:09 -0300, Adriano dos Santos Fernandes пишет: > On 29/08/2011 08:35, Alexander Peshkov wrote: > > В Вс., 28/08/2011 в 19:14 -0300, Adriano dos Santos Fernandes пишет: > >> All, > >> > >> After I bought a new machine, I reinstalled Ubuntu > > 11.04? > > Yes. Kernel is 2.6.38.

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 08:35, Alexander Peshkov wrote: > В Вс., 28/08/2011 в 19:14 -0300, Adriano dos Santos Fernandes пишет: >> All, >> >> After I bought a new machine, I reinstalled Ubuntu > 11.04? Yes. Kernel is 2.6.38. >> in new HDD with ext4 >> filesystem. >> >> While the new machine has much bett

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Alexander Peshkov
В Пн., 29/08/2011 в 16:11 +0200, Paul Reeves пишет: > The levels are > > Application - we can set FW=ON or OFF. If ON the we are saying write > everything to disc immediately. If FW=OFF then we see a massive performance > gain on small test runs (especially if super* is used.) > > Filesystem

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 15:27 Adriano dos Santos Fernandes wrote: > > > > The default for ext3/4 is data=ordered and, from the kernel docs: > I read divergent things about this. Some says that ext3 default changed > to writeback, others says it depends from a kernel configure option. I have

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 15:30 Adriano dos Santos Fernandes wrote: > On 29/08/2011 10:24, Paul Reeves wrote: > > On Monday 29 August 2011 at 13:35 Alexander Peshkov wrote: > >> Tested CREATE DATABASE on my old box. To avoid disk fragmentation > >> effects database was always created on new shin

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 10:24, Paul Reeves wrote: > On Monday 29 August 2011 at 13:35 Alexander Peshkov wrote: > >> Tested CREATE DATABASE on my old box. To avoid disk fragmentation >> effects database was always created on new shining partition. >> > I've found different results doing a large db restore. ex

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 10:13, Paul Reeves wrote: > On Monday 29 August 2011 at 14:25 Michael Weissenbacher wrote: > >>> But if barriers are needed just to make journal commits safe on the disk >>> with write cache turned on this seems to be not directly related with >>> firebird databases - write cache ON w

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 13:35 Alexander Peshkov wrote: > > Tested CREATE DATABASE on my old box. To avoid disk fragmentation > effects database was always created on new shining partition. > I've found different results doing a large db restore. ext4 came out better than ext3. I also found

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 14:25 Michael Weissenbacher wrote: > > But if barriers are needed just to make journal commits safe on the disk > > with write cache turned on this seems to be not directly related with > > firebird databases - write cache ON will anyway break firebird database > > in c

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Michael Weissenbacher
> > But if barriers are needed just to make journal commits safe on the disk > with write cache turned on this seems to be not directly related with > firebird databases - write cache ON will anyway break firebird database > in case of crash. Or may be this option actually deals with all data on >

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Michael Weissenbacher
> > Adriano, I'm not sure why you replied to my comment - I was making the same > point as Torvalds, but with irony instead of insulting morons :-) > > > Paul I guess he was missing the tag :-) -- EMC VNX: the world'

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Jorge Andrés Brugger
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 b

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 14:22 Alexander Peshkov wrote: > > Paul, telling true I've also not understood a humor. May be that's > because I and Adriano are not native english speakers? > Probably :-) I can't say for other langauges but irony is used a lot in english. When we say someone or s

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Alexander Peshkov
В Пн., 29/08/2011 в 14:16 +0200, Paul Reeves пишет: > On Monday 29 August 2011 at 12:47 Adriano dos Santos Fernandes wrote: > > > On 29/08/2011 06:27, Paul Reeves wrote: > > > On Monday 29 August 2011 at 11:05 marius adrian popa wrote: > > >> you are not the only one that observed db/vm performanc

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 12:47 Adriano dos Santos Fernandes wrote: > On 29/08/2011 06:27, Paul Reeves wrote: > > On Monday 29 August 2011 at 11:05 marius adrian popa wrote: > >> you are not the only one that observed db/vm performance issues with > >> ext4 maybe you need to mount it with data=w

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Alexander Peshkov
В Пн., 29/08/2011 в 07:47 -0300, Adriano dos Santos Fernandes пишет: > On 29/08/2011 06:27, Paul Reeves wrote: > > On Monday 29 August 2011 at 11:05 marius adrian popa wrote: > > > > > >> you are not the only one that observed db/vm performance issues with ext4 > >> maybe you need to mount it with

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Alexander Peshkov
В Вс., 28/08/2011 в 19:14 -0300, Adriano dos Santos Fernandes пишет: > All, > > After I bought a new machine, I reinstalled Ubuntu 11.04? > 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 wa

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 06:05, marius adrian popa wrote: > On Mon, Aug 29, 2011 at 1:14 AM, Adriano dos Santos Fernandes > wrote: >> 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

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 06:27, Paul Reeves wrote: > On Monday 29 August 2011 at 11:05 marius adrian popa wrote: > > >> you are not the only one that observed db/vm performance issues with ext4 >> maybe you need to mount it with data=writeback >> >> http://blog.smartlogicsolutions.com/2009/06/04/mount-options

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Paul Reeves
On Monday 29 August 2011 at 11:05 marius adrian popa wrote: > you are not the only one that observed db/vm performance issues with ext4 > maybe you need to mount it with data=writeback > > http://blog.smartlogicsolutions.com/2009/06/04/mount-options-to-improve-ext > 4-file-system-performance/ >

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread marius adrian popa
On Mon, Aug 29, 2011 at 1:14 AM, Adriano dos Santos Fernandes wrote: > 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 da