Collections:
Data File for InnoDB Storage Engine in MySQL
Where Table Data Is Stored by the InnoDB 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, 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 ...
⇒ Tables Using BDB Storage Engine in MySQL
⇐ Tables Using InnoDB Storage Engine in MySQL
2017-08-13, 1620🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...