The base directory for
BDB tables. This
should be the same directory that you use for
BDB lock detection method. The option
value should be
BDB log file directory.
Do not start Berkeley DB in recover mode.
Start Berkeley DB in multi-process mode. (Do not use
DB_PRIVATE when initializing Berkeley
BDB temporary file directory.
BDB storage engine.
Synchronously flush the
BDB logs. This
option is enabled by default. Use
to disable it. This option was added in MySQL 4.0.18.
If you use the
MySQL does not initialize the Berkeley DB library and this saves
a lot of memory. However, if you use this option, you cannot use
BDB tables. If you try to create a
BDB table, MySQL uses the default storage
Normally, you should start mysqld without the
--bdb-no-recover option if you
intend to use
BDB tables. However, this may
cause problems when you try to start mysqld
BDB log files are corrupted. See
Section 18.104.22.168, “Starting and Troubleshooting the MySQL Server”.
you can specify the maximum number of locks that can be active
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 ...
See also Section 5.1.3, “Server System Variables”.