(mysql.info.gz) BDB start
Info Catalog
(mysql.info.gz) BDB install
(mysql.info.gz) BDB storage engine
(mysql.info.gz) BDB characteristics
14.4.3 `BDB' Startup Options
----------------------------
The following options to `mysqld' can be used to change the behavior of
the `BDB' storage engine:
`--bdb-home=PATH'
The base directory for `BDB' tables. This should be the same
directory you use for `--datadir'.
`--bdb-lock-detect=METHOD'
The `BDB' lock detection method. The option value should be
`DEFAULT', `OLDEST', `RANDOM', or `YOUNGEST'.
`--bdb-logdir=PATH'
The `BDB' log file directory.
`--bdb-no-recover'
Don't start Berkeley DB in recover mode.
`--bdb-no-sync'
Don't synchronously flush the `BDB' logs.
`--bdb-shared-data'
Start Berkeley DB in multi-process mode. (Don't use `DB_PRIVATE'
when initializing Berkeley DB.)
`--bdb-tmpdir=PATH'
The `BDB' temporary file directory.
`--skip-bdb'
Disable the `BDB' storage engine.
Server options.
The following system variable affects the behavior of `BDB' tables:
`bdb_max_lock'
The maximum number of locks you can have active on a `BDB' table.
Server system variables.
If you use the `--skip-bdb' option, MySQL will not initialize the
Berkeley DB library and this will save a lot of memory. However, if
you use this option, you cannot use `BDB' tables. If you try to create
a `BDB' table, MySQL will create a `MyISAM' table instead.
Normally, you should start `mysqld' without the `--bdb-no-recover'
option if you intend to use `BDB' tables. However, this may give you
problems when you try to start `mysqld' if the `BDB' log files are
corrupted. Starting server.
With the `bdb_max_lock' variable, you can specify the maximum number of
locks that can be active on a `BDB' table. The default is 10,000. You
should increase this if errors such as the following occur when you
perform long transactions or when `mysqld' has to examine many rows to
execute a query:
bdb: Lock table is out of available locks
Got error 12 from ...
You may also want to change the `binlog_cache_size' and
`max_binlog_cache_size' variables if you are using large
multiple-statement transactions. Binary log.
Info Catalog
(mysql.info.gz) BDB install
(mysql.info.gz) BDB storage engine
(mysql.info.gz) BDB characteristics
automatically generated byinfo2html