How can I tell which architecture is installed/configured/running on an existing installation of Firebird RDBMS server (ie. Classic Server or Super-Server)?
How can I switch between the two modes?
Which versions (1.5, 2.0, 2.1) and architectures (CS or SS) of Firebird can be used on multi-processor servers? and how to configure them properly for multi-processor sever and multi-threaded application?
views:
238answers:
1
+2
A:
1 -- To tell which architecture is running open Task Manager and look at running processes. fb_inet_server.exe stands for classic architecture, and fbserver.exe -- super server.
2 -- Close all client connections. Got to Firebird\Bin directory. Execute specified sequence of commands:
instsvc stop
instsvc remove
then either:
instsvc install -s -a -- for Super Server
or
instsvc install -c -a -- for Classic
after that:
instsvc start
3 -- Super Server always runs on single processor or core and can not scale. Use Classic architecture in SMP environment. In latter case dont specify page buffers more than 800-1000.
Be aware that performance of Classic Server depends on performance of disk subsystem. For big databases use RAID controllers with internal cache memory, battery and "write back" mode enabled.
Andrei K.
2009-12-18 09:46:58
thanks Andrei - any documentation regarding configuring Firebird to use multiple cpu's or is it automatically detected? Is it all in firebird.conf? Will Classic Server support a multi-threaded application too? spasiba.
Sam
2009-12-18 10:20:17
in addition to 3 you can look this http://www.firebirdsql.org/manual/qsg2-classic-or-super.html
Hugues Van Landeghem
2009-12-18 17:39:47
2 Sam:Nope. There is no autodetection envolved. Superserver always load only ONE CPU or core. And Classic use one process per client connection. So OS will distribute processes among available CPUs.BTW. "spasiba" sounds like "dziakuj" in belarusian ;)
Andrei K.
2009-12-25 14:41:42