hi,
recently we had some strange performance issues with our Firebird DB server.
On high load, our server started to slow down. Select and update SQL query
times did go up by more than 500% on average,
but reaching unreasonable high execution times at worst case. (several minutes
instead of <
Hi Thomas, nice to get a response from you. We already met in ~2010 in Linz at
your office :)
(ex. SEM GmbH, later Playmonitor GmbH)
First, sorry for posting a mixed state of informations. The config settings i
postet are the current settings.
But the Lock-Table-Header was from last saturda
Hey,
not sure how you can survive with superserver :)
I can't see that working with our kind of load (realtime-data-processing,
reports, mostly write IOPS)
It's a long time ago (Fb 1.5) since we used superserver but we didn't have the
best time with it back then.
But currently this is not about
Hey Alexey,
thanks you for our input. I think what you say is correct, and we reviewed our
disk setup again.
We are utilizing mechnical discs so it's kinda hard to compare SSD performance
to them.
But they should provide enought IOPS for our load.
Unfortunatly we can't just switch to a single
Hey Thomas,
thanks for your extensive reply.
Unfortunatly we'r still bound to some old 32bit UDF functionality which we
can't get in 64bit.
I think you know about the use of SuperClassic with 32bit Server - 2GB RAM
Limit :)
It's not impossible, but also not really a fast route we can go. But for
1) We have sweep set to 0. We do monitor the transaction gab and if needed, we
interact. Any kind of automatic sweep under high load will kill the server :)
2) We do run gbak daily. We do not use nbackup - we would like to and tried it
but it's corrupting the db.
3) We do use read-only re
We splitted our system now to 2 databases, reducing the connections to about
250 per DB.
Running on same Hardware (same SAN-Storage) and splitted the CPU ressources.
Both system seems stable now, but that's not really a solution we prefered.
Just helps us to not lose customers at the moment.