Firebird CpuAffinityMask for 16 core server?

Question

I have a server with 16 cores. What do I set the CpuAffinityMask to?

1111 1111 1111 1111 is 65535, should I put 65535?

Also, how to I configure the SuperClassic server?

This is for Firebird 2.5.

TIA

Answer 1

From the documentation:

Windows Superserver defaults to using the first logical processor only, because prior to 2.5 it performed badly on SMP systems. To make use of all your processors, set the CpuAffinityMask parameter in firebird.conf to: 3 for 2 CPUs/cores; 15 for 4 CPUs/cores; 255 for 8 CPUs/cores.

So, yes, 65535 = 2¹⁶-1 is the correct setting to use all of your 16 cores.

Answer 2

As far as I know only SuperServer follows the CpuAffinityMask, see Firebird Architectures, so for SuperClassic this configuration value is ignored and it will always be able to use all available CPUs

Answer 3

Setting CpuAffinityMask to 65535 is only useful if youre
- running SuperServer (not classic or superclassic)
- and you are communicating with 16 or more databases simultaneously (1 core per database)

If you have just 1 FB-database running, setting this option sounds only useful to me if you want to dedicate a specific core to Firebird instead of using the default first core.

If you want to make Firebird use of all your cores, please consider installing Firebird in classic/superclassic-mode.