Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Where Table Data Is Stored by the InnoDB Storage Engine
Where Table Data Is Stored by the InnoDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: FYIcenter.com
By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, InnoDB storage engine will create 3 files to store and manage all tables that use the InnoDB storage engine:
If a new table is created with the InnoDB storage engine, one format file named as databaseName\tableName.frm will be created. Table data and index data will be stored in "ibdata1". For example, the new table "fyi_inno" created in the previous tutorial exercise will result the following files:
>cd \mysql\data >dir fyi\fyi_inno.* 8,620 fyi_inno.frm >dir 10,485,760 ibdata1 5,242,880 ib_logfile0 5,242,880 ib_logfile1 ...
2007-05-10, 4670👍, 0💬
Popular Posts:
What is the difference between strings and character arrays? A major difference is: string will have...
.NET INTERVIEW QUESTIONS - What is the difference between thread and process? A thread is a path of ...
What is ISO? ISO 9000 is a family of standards for quality management systems. ISO 9000 is maintaine...
Wha is the output from System.out.println("Hell o"+null);?Hellonull
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump...