Subject Re: [firebird-support] RE: very slow inserts with blob-fields
Author Carlos H. Cantu
Post date 2014-03-06T19:46:29Z
Re: [firebird-support] RE: very slow inserts with blob-fields Firebird performance with forced-writes databases stored in linux partitions with Barrier parameter turned enabled is horrible for writings. You may not notice if you have slow volume of sporadic writings, but it becomes a real problem if you have "mass writings", like DML that will affect several records.

Solution is to disable FW or disable Barrier. So far, I really don't know what of this options would be better regarding "safety/stability".

[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br


Em 6/3/2014 07:06, Bryan Cole escreveu:
On Wed, 2014-03-05 at 22:40 -0800, ma_golyo@... wrote:
 
Hi!

Firebird do not like ext4 FS. You must chane some settings.

http://www.firebirdnews.org/?p=6421


Thanks for the tip. Remounting my ext4 partition with barrier=0 increased the write speed from ~8 rows/sec to 450 rows/sec. Yeay.

There are a bewildering array of linux filesystem options I could look at tuning further. Can anyone recommend a good combination (ext3 vs ext4,xfs,btrfs with options writeback-vs-ordered, barriers etc.) for a firebird database. I can afford to lose a few seconds of data in the event of a hard crash, but the filesystem/database as whole needs to remain consistent.

Thanks,
Bryan




This is something I don't master and I really like to know about it... If someone has numbers or information about this I would love to know.