“Per-database” Configuration

Format of Configuration Entries
Parameters Available

Custom configuration at database level is achieved with formal entries in databases.conf.

Format of Configuration Entries

In aliases.conf the format for specifying a database alias was

 aliasname = /absolute/path/to/database_file

If you are not adding any database-specific configuration directives for an alias, the format is just as it was before, e.g.,

  emp = c:\Program Files\examples\empbuild\employee.fdb
 ** or  **
  emp = /opt/firebird/examples/empbuild/employee.fdb
 ** or  **
  emp = $(dir_sampleDb)/employee.fdb

A slightly more complex format is used for cases where certain non-global parameters are to be targeted at an indvidual databases. The entry for the database is defined by the alias declaration, as previously. The database-specific directives are listed below it, within curly brackets.

  #
  # Directives for MYBIGDB
  MYBIGDB = opt/databases/mybigdb.fdb
     {
        LockMemSize = 32M           # We know that MYBIGDB needs a lot of locks
        LockHashSlots = 19927       # and a hash table large enough for them
     }

Parameters Available

The following parameters can be copy/pasted to databases.conf and used as overrides for specific databases.

Table 6.1. Parameters available in databases.conf

Engine-related
DatabaseGrowthIncrement	DeadlockTimeout	DefaultDbCachePages
EventMemSize	FileSystemCacheThreshold	ExternalFileAccess
GCPolicy	LockAcquireSpins	LockHashSlots
LockMemSize	MaxUnflushedWrites	MaxUnflushedWriteTime
SecurityDatabase	UserManager
WireCompression	WireCrypt	WireCryptPlugin
Client-related	Some parameters can be configured at the client connection via the DPB/SPB, as an alternative to configuring them in `databases.conf`. Please refer back to Scope of Parameters at the beginning of this chapter to understand these differences.
AuthClient	Providers
The following parameters can be configured ONLY via the DPB/SPB
ConnectionTimeout	DummyPacketInterval	IpcName
RemoteAuxPort	RemotePipeName	RemoteServiceName
RemoteServicePort	TCPNoNagle