Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 64: Which files does a MyIsam table consist of? – MySQL Question of the Day

Skip to content

Question 64: Which files does a MyIsam table consist of?

10. June 2010
By plogi in mysql questions

1 Comment

(Select all correct answers)

a) .frm file
b) .dat file
c) db.opt file
d) .MYD file
e) .MYI file

 
[ MySQL Architecture (10%) - How MySQL uses Disk Space ]
 

Tags: , ,

Comment Feed

One Response

  1. plogi — 10. June 2010 @ 20:02:48 —


    a d e
     
    The .frm file is not specific to MyIsam, but it is created when any table is created. The form file contains the table & column definitions.
    In the .MYD file the table data is stored, and the indexes go into the MYI file.
    When a database is created, then the db.opt file is written. It contains database settings like the default charset.

You must be logged in to post a comment.