What is the difference between MyISAM dynamic and MyISAM static in MySQL?
Answer»
MyISAM Dynamic
MyISAM static
This is a table storage FORMAT which is basically used when some columns in the existing tables use variable data types such as VARCHAR, BLOB, TEXT, VARBINARY, etc.)
This is also a table storage format which is basically used when all columns in the existing table’s uses FIXEDWIDTH data types.