Two Most Popular Storage Engines in MySql are InnoDB and MyISAM

1. InnoDB supports supports transactions which is not supported by MyISAM storage engine in tables.

2. InnoDB has record(row) level locking, relational integrity means supports foreign keys, which is not possible in MyISAM tables.

3. Performance of InnoDB for high volume data cannot be beaten by MyISAM engines.

4. Only the speed of tables are higher in case of MyIASM but due to of (InnoDB supports volume, transactions, integrity ) it is more popular.

5. MyISAM stores each table on disk with three files whose names begin with same as table name. These files have different extensions to differentiate their purpose. A .frm files stores the table format, and a .MYD (MYData) file stores the data of the table. If the table has indexes then these are stored in the .MYI (MYIndex) files.

6. InnoDB tables and their indexes are stored in the tablespace, which consists of several files. That is why InnoDB tables can be very large and can store large volume of data. The InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory.

Check the engines being used for existing tables

7. Syntax of InnoDB ==================

CREATE TABLE sukant test varchar(30) ENGINE = InnoDB;

It is also possible to convert from one engine to the other by command: ALTER TABLE tablename ENGINE=new_engine_name;

Syntax of MyISAM ================

Since MyISAM is the default engine assigned when creating a table, so you need not to specify it
Syntax of displaying the table status =======================================

show table status;

for perticular table status =================

show table status where Name = ‘tablename’;