Subject RES: SV: [firebird-support] FB on Linux installation question
Author Fabiano
What are the file system used?

What the kernel version of CentOS 6.3?


[] Em nome de jugglingjester
Enviada em: segunda-feira, 23 de julho de 2012 13:42
Assunto: Re: SV: [firebird-support] FB on Linux installation question


i've done a little bit of connection and load testing the last days.

Used an old HP Compaq 6910p, 2 Cores, 4 GB RAM, 4 GB SWAP as server, running
on CEntOS 6.3. Installed with the minimal ISO, using only the CEntOS
Installed Firebird 2.5.1 from the .tar.gz, not the rpm.

Our developers have provided me with a testing tool to open n connections
and start a query in each connection.

500 Connections+ from 4 client, no error at all. Peaking at roundabout
750-800 connections the "server" wasn't able to response due to massive
swapping. Less than 5 % RAM and 5 % swap free, left the clients and the
server for an hour (went for lunch :-) in that condition - not an error at

hth, Marcus

--- In
<> , Poul Dige <pd@...> wrote:
> Hi Fabiano,
> We tried 2.5.1 SC on Ubuntu 11. We had quite strange experience with the
FB-server constantly crashing (every 20 minutes or so) with anything from
40-150 connections, AFAIR. No data corruption, but lots of annoyed
customers. We switched to W2k8 and the problem was gone. I'd love to find
out what went wrong but we were in no position to "experiment" as it was
production environment, so it just had to work. Unfortunately, as I'd prefer
to run it under Linux.
> I don't say that you will experience the same, but do be aware if it
> Best regards
> Poul
> Fra:
<> ] På vegne af Fabiano
> Sendt: 23. juli 2012 15:17
> Til:
> Emne: [firebird-support] FB on Linux installation question
> Hi all.
> A new customer Will use a Linux machine to run the Firebird server.
> he will be the first customer to do that.
> I have read that (at last with FB 1.5 to 2.0) the linux kernel need to be
> 2.4.x to run Classic with a lot of connections.
> This issue also occurs on FB 2.5.1 Classic?
> Another tip is that writes on ext4 file system is slower than ext3 if
> 'barrier' was ON. I can figure out the best file system to this customer.
> Ext4 with/without barrier or ext3? The best for me is stability, I don't
> want to easily corrupt my database on a fast partition. (power down
> problems, etc).
> What are the best fast/secure balanced partition type?
> And finally - forced writes. I read that this configuration works on Linux
> with FB 2.5.x. What is the best configuration?
> It someone have any tips of software installation on linux and maybe
> hardware please fells free to answer.
> Thanks, Fabiano.
> [Non-text portions of this message have been removed]
> [Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]