MySQL Storage - Where Table Data Is Stored by the BDB Storage Engine
Interview Question Database For Software Developers
|
|
| Where Table Data Is Stored by the BDB Storage Engine | | Where Table Data Is Stored by the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB | | By: FYIcenter.com | By default, MySQL provides \mysql\data directory for all storage engines to store table data.
Under \mysql\data directory, the BDB storage engine will create one file for each table to store
table data and index data.
If a new table is created with the BDB storage engine, one format file named as databaseName\tableName.frm
will be created. Another file named as databaseName\tableName.db to store table data and index data.
For example, the new table "fyi_bdb" created in the previous tutorial exercise will result the following files:
>cd \mysql\data
>dir fyi\fyi_bdb.*
49,152 fyi_bdb.db
8,620 fyi_bdb.frm
| | ID: 984 | Rank: 1227 | Votes: 0 | Views: 90 | Submitted: 20070510 |
Copyright © 2010 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view