Subject | Re[2]: [firebird-support] Classic to Super Server |
---|---|
Author | André Knappstein, Controlling |
Post date | 2008-09-15T09:49:31Z |
Hi Mitch!
If it's Windoof you're installing it on then mind the zombies!
FB 1.5.x has a problem with connections kept alive, resources kept
reserved. Only affects CS on Windows, not SS on Windows, not anything
on Linux. I reported that and it finally was proven an existing bug
and was fixed in 2.x, but not backported to 1.5.x.
Those zombies won't harm me on the old 1.5 CS I have, because I know
the maximum amount of resources for the highest possible number of
zombies in our company, and that server is fit for that.
Can be bad though if the highest number of possible connections
exceeds the abilities of your server.
ciao,
André
~~~Ihre Nachricht~~~
MP> Steve Harp wrote:
MP> don't have similar regrets.
MP> I do have a question regarding shutting down firebird. It seems that
MP> doing a database shut down (forced even) will prevent new processes from
MP> spawning/connecting, it does nothing to those that are still running.
MP> in fact, they continue to be able to access the database.
MP> Neither does shutting down the firebird service remove those running
MP> processes. However, they are no longer functional with regards to
MP> accessing the data.
MP> Is there a protocol for shutting down classic (perhaps to obtain
MP> exclusive access, for metadata changes, etc.?
MP> Thanks,
MP> Mitch
MP> ------------------------------------
MP> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MP> Visit http://www.firebirdsql.org and click the Resources item
MP> on the main (top) menu. Try Knowledgebase and FAQ links !
MP> Also search the knowledgebases at http://www.ibphoenix.com
MP> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MP> Yahoo! Groups Links
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 0
Telefax: +49 2389 9240 150
e-mail: info@...
Amtsgericht Hamm Nr. B 420 || USt-IDNr.: DE 125215402
Geschäftsführer: Achim Krähling, Dirk Salewski, Matthias Steinhaus
If it's Windoof you're installing it on then mind the zombies!
FB 1.5.x has a problem with connections kept alive, resources kept
reserved. Only affects CS on Windows, not SS on Windows, not anything
on Linux. I reported that and it finally was proven an existing bug
and was fixed in 2.x, but not backported to 1.5.x.
Those zombies won't harm me on the old 1.5 CS I have, because I know
the maximum amount of resources for the highest possible number of
zombies in our company, and that server is fit for that.
Can be bad though if the highest number of possible connections
exceeds the abilities of your server.
ciao,
André
~~~Ihre Nachricht~~~
MP> Steve Harp wrote:
>> Hi All,MP> i am switching to Classic today 1.5.x. New box, quad core. Hope I
>>
>>
>>
>> I've recently found out that our previous system admin installed classic
>> server instead of super server. Our performance with respect to server
>> connections leaves much to be desired and I'm assuming that the classic vs.
>> super could have something to do with it.
>>
>>
>>
MP> don't have similar regrets.
MP> I do have a question regarding shutting down firebird. It seems that
MP> doing a database shut down (forced even) will prevent new processes from
MP> spawning/connecting, it does nothing to those that are still running.
MP> in fact, they continue to be able to access the database.
MP> Neither does shutting down the firebird service remove those running
MP> processes. However, they are no longer functional with regards to
MP> accessing the data.
MP> Is there a protocol for shutting down classic (perhaps to obtain
MP> exclusive access, for metadata changes, etc.?
MP> Thanks,
MP> Mitch
MP> ------------------------------------
MP> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MP> Visit http://www.firebirdsql.org and click the Resources item
MP> on the main (top) menu. Try Knowledgebase and FAQ links !
MP> Also search the knowledgebases at http://www.ibphoenix.com
MP> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MP> Yahoo! Groups Links
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 0
Telefax: +49 2389 9240 150
e-mail: info@...
Amtsgericht Hamm Nr. B 420 || USt-IDNr.: DE 125215402
Geschäftsführer: Achim Krähling, Dirk Salewski, Matthias Steinhaus