DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) bdb-start

Info Catalog (mysql.info) bdb-install (mysql.info) bdb-storage-engine (mysql.info) bdb-characteristics
 
 14.5.3 `BDB' Startup Options
 ----------------------------
 
 The following options to `mysqld' can be used to change the behavior of
 the `BDB' storage engine. For more information, see 
 server-options.
 
    * -bdb-home=PATH
 
      The base directory for `BDB' tables. This should be the same
      directory that 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=FILE_NAME
 
      The `BDB' log file directory.
 
    * -bdb-no-recover
 
      Do not start Berkeley DB in recover mode.
 
    * -bdb-no-sync
 
      Don't synchronously flush the `BDB' logs.  This option is
      deprecated; use -skip-sync-bdb-logs instead (see the description
      for -sync-bdb-logs).
 
    * -bdb-shared-data
 
      Start Berkeley DB in multi-process mode. (Do not use `DB_PRIVATE'
      when initializing Berkeley DB.)
 
    * -bdb-tmpdir=PATH
 
      The `BDB' temporary file directory.
 
    * -skip-bdb
 
      Disable the `BDB' storage engine.
 
    * -sync-bdb-logs
 
      Synchronously flush the `BDB' logs. This option is enabled by
      default. Use -skip-sync-bdb-logs to disable it.
 
 If you use the -skip-bdb option, 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 engine instead.
 
 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' if the `BDB' log files are corrupted. See
  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. See  binary-log.
 
 See also  server-system-variables.
 
Info Catalog (mysql.info) bdb-install (mysql.info) bdb-storage-engine (mysql.info) bdb-characteristics
automatically generated byinfo2html