adspace


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What is the difference between myisam dynamic and myisam static in mysql?

Question Posted / Karan Srivastava

Answer Posted / Karan Srivastava

MyISAM Dynamic tables have a heap file that stores data, while MyISAM Static tables store data in both a .MYD (Data) file and a .MYI (Index) file. In MyISAM Dynamic tables, the .frm file contains information about table structure including column names and types. However, in MyISAM Static tables, this information is stored in separate .MYI files.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105

What is current version of mysql?

1084

Which statement is used in a select query for partial matching?

1247

How to Change a users password from unix shell.

1223