Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Nov 19 '11 at 23:41

This question came from our site for professional and enthusiast programmers.

2  
Why do you need to set the mask? –  David Heffernan Oct 31 '11 at 20:18
1  
@DavidHeffernan I want all 16 cores to be used by the Firebird server. By default, the CpuAffinityMask is set to 1, which means that just the first processor (core) is going to be used. –  ioan Oct 31 '11 at 21:38
1  
I would have expected it to default to all processors. Perhaps I'm naive. According to docs, 65535 is indeed the correct value. –  David Heffernan Oct 31 '11 at 21:42

3 Answers 3

up vote 5 down vote accepted

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 = 216-1 is the correct setting to use all of your 16 cores.

share|improve this answer

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.