Re: [firebird-support] RE: very slow inserts with blob-fields

2014-03-06 Thread Bryan Cole
On Wed, 2014-03-05 at 22:40 -0800, ma_go...@yahoo.com 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





Re: [firebird-support] RE: very slow inserts with blob-fields

2014-03-06 Thread Alexandre Benson Smith

Em 6/3/2014 07:06, Bryan Cole escreveu:



On Wed, 2014-03-05 at 22:40 -0800, ma_go...@yahoo.com 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.





Re: [firebird-support] RE: very slow inserts with blob-fields

2014-03-06 Thread Carlos H. Cantu













Re: [firebird-support] RE: very slow inserts with blob-fields

2014-03-06 Thread Carlos H. Cantu













[firebird-support] RE: very slow inserts with blob-fields

2014-03-05 Thread ma_golyo
Hi!

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

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