Collections:
Data File of BDB Storage Engine in MySQL
Where Table Data Is Stored by the BDB Storage Engine in MySQL?
✍: 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
2017-08-13, 663👍, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...