Explain the difference between MyISAM Static and MyISAM
Dynamic?
Answer Posted / amith
In MyISAM static all the fields have fixed width. The
Dynamic MyISAM table would include fields such as TEXT,
BLOB, etc. to accommodate the data types with various
lengths.
MyISAM Static would be easier to restore in case of
corruption, since even though you might lose some data, you
know exactly where to look for the beginning of the next
record.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How is data stored in mysql?
Is mysql running ubuntu?
Which datatype is used for email in mysql?
What is mysql sleep process?
What is general log in mysql?
What is blob storage?
How do I start mysql database?
I want to start and stop mysql on windows? How do I do that?
What are date and time data types?
Is sqlite faster than mysql?
Can mysql store files?
What are the differences between char and varchar?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
Can I use mariadb instead of mysql?
What are the differences between innodb and myisam engines?