Subject | Re: 2nd: firebird sharing I/O with other programs |
---|---|
Author | diwic2 |
Post date | 2005-06-26T11:47:18Z |
> FW On or FW Off are the only relvant settings here. You can also puta
> middle tier in to consolidate transactions. Or you can rotate thoselogs a
> little more intelligently and store them off the machine in questionThanks for your answer. I'm still puzzled that it takes so long time
> Alan
though. If the programs accessing the firebird database are offline,
reading the log takes about five seconds (6 MB/s), and when online
reading the log takes three minutes (0,2 MB/s. If the OS was a fair
guy, it would give 50% of the I/O time to firebird and 50% of the time
to reading the log file. But it seems like firebird gets 97% of the
physical disk time and reading the log file gets about 3%.
I know firebird uses some flags when writing to the disk, I think
write_through is one of them. Could that make the OS think that
firebird's writes are more important? (Perhaps this is a discussion
for firebird-devel?)
// David