1. Explain the difference MyISAM Static and MyISAM Dynamic.
Ans- in MyISAM static all the fields have fixed width. The Dynamic
MyISAM 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.
2. What does myisamchk do?
It compressed the MyISAM tables , which reduces their disk
usage.
3. Explain advantages of InnoDB over MyISAM?
Row level locking,
transactions, foreign key constraints and crash recovery.
4. Explain advantages of MyISAM over InnoDB?
Much more conservative approach to disk space management
each MyISAM table is stored in a
separate file, which could be compressed then with myisamchk if needed. With InnoDB
the tables are stored in tablespace, and much further optimization is possible.
All data except for TEXT and BLOB can occupy 8,000 bytes at most. No full text
indexing is available for InnoDB.TRhe COUNT(*)s execute slower than in MyISAM
due to tablespace complexity.
5. What are HEAP tables in MySQL?
HEAP tables are in memory. They are usually used for
high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP
tables. You can only use the comparison operators = and <=>. HEAP tables
do not support AUTO_INCREAMENT. Indexes must be NOT NULL.
6. How do you control the max size of a HEAP table?
MySQL config variable max_heap_table_size
7. What are CSV tables?
Those are the special tables, data for which is saves into comm.-separate
values file. They cannot be indexed.