Explain how to create a new table using BDB Storage Engine.
- BDB (BerkeleyDB) storage engine is transaction safe and developed by Oracle.
- BDB is not the default storage engine. "ENGINE = BDB" at the end of the "CREATE TABLE" statement can be specified to create new tables with the BDB storage engine.
- Each BDB table is stored on disk in two files.
- The files have names that begin with the table name and have an extension to indicate the file type.
- An .frm file stores the table format, and a .db file contains the table data and indexes.
- To specify explicitly that you want a BDB table, indicate that with an ENGINE table option:
CREATE TABLE t (i INT) ENGINE = BDB;
- The older term TYPE is supported as a synonym for ENGINE for backward compatibility, but ENGINE is the preferred term and TYPE is deprecated.
- BerkeleyDB is a synonym for BDB in the ENGINE table option.
