Atom feed of this document
 

 Database

Use the following options to alter Database-related settings.

Table 4.33. Description of configuration options for db
Configuration option=Default value Description
backend=sqlalchemy (StrOpt) The backend to use for db
connection=sqlite:// (StrOpt) The SQLAlchemy connection string used to connect to the database
connection_debug=0 (IntOpt) Verbosity of SQL debugging information. 0=None, 100=Everything
connection_trace=False (BoolOpt) Add python stack traces to SQL as comment strings
dhcp_agents_per_network=1 (IntOpt) Number of DHCP agents scheduled to host a network.
idle_timeout=3600 (IntOpt) timeout before idle sql connections are reaped
max_overflow=20 (IntOpt) If set, use this value for max_overflow with sqlalchemy
max_pool_size=10 (IntOpt) Maximum number of SQL connections to keep open in a pool
max_retries=10 (IntOpt) maximum db connection retries during startup. (setting -1 implies an infinite retry count)
min_pool_size=1 (IntOpt) Minimum number of SQL connections to keep open in a pool
pool_timeout=10 (IntOpt) If set, use this value for pool_timeout with sqlalchemy
retry_interval=10 (IntOpt) interval between retries of opening a sql connection
slave_connection= (StrOpt) The SQLAlchemy connection string used to connect to the slave database
sqlite_db= (StrOpt) the filename to use with sqlite
sqlite_synchronous=True (BoolOpt) If true, use synchronous mode for sqlite
use_tpool=False (BoolOpt) Enable the experimental use of thread pooling for all DB API calls

Log a bug against this page


loading table of contents...