MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 

How MySQL myisam table is stored on disk?

I am learning MySQL storage engines. I need some help about MySQL MyISAM storage engine. Can you help me to explain, how MySQL MyISAM table is stored on disk?

Answer No: 168

MySQL stores each MyISAM table on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type.

1. An .frm file stores the information about table format.
2. The file containing table data has an .MYD (MYData) extension.
3. The file containing information about table indexes has an .MYI (MYIndex) extension.

Related MySQL FAQs to the Above FAQ

What-are-MyISAM-table-characteristics What are MyISAM table characteristics?

What-are-MyISAM-formats-in-MySQL What are MyISAM formats in MySQL?

How-to-create-myisam-table-in-MySQL How to create myisam table in MySQL?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.