Explain the difference between MyISAM Static and MyISAM Dynamic. ?

devquora
devquora

Posted On: Feb 22, 2018

 

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mysql Interview Questions

    What is MySql ?

    MySql is a multi-threading, multi-user open source SQL database management system . It is typically used for web applica..

    Mysql Interview Questions

    In which language MYSQL it is written ?

    MySql is written in C and C++ programming and SQL parser written in yacc...