DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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