CODEWITHSUNDEEP
mysqlindexing
Uday
Uday

Reputation: 1490

What data is stored in the index file of mysql

I am recently working on better indexing concepts. as part of that, I am curious to know what is that stored in the index file(.MYI file) if that is a MYISAM table or the shared table space if that is an INNODB table..?

To give you more clarity, I know that when we create an index, the table will be re created updating the index filed or file. I would like to know what is the data used to update the index field..?

Upvotes: 1

Views: 3044

Answers (2)

Ashwin A
Ashwin A

Reputation: 3867

A .MYI file is for a MyISAM table contains the table's indexes. And file has two parts- the header information and the key values.

This explains in detail about internals of MyISAM and this about .MYI file

Upvotes: 2

user1285324
user1285324

Reputation:

index theory

go to the link two know about index.

Upvotes: 1

Related Questions