Use the following options to alter Database-related settings.
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 |