There are two main difference are as follows:
1. Supports for Pluggable Storage Engine
2. Supports for Table Partition.
Pluggable Storage Engine:
storage engine can be processed dynamically by MySQL server 5.1.
storage engines to be loaded by INSTALL PLUGIN statement.
storage engines to be unloaded by UNINSTALL PLUGIN statement.
we can partition table when creating table. If needed we can also create sub partition too.
The Things we have to consider
1. Database Level Collation Type
2. Table Level Collation Type
3. Fields Level Collation Type
What is Relational Database Design Patterns?
What is Federated storage engine?
What is Merge storage engine?
What is USE INDEX, FORCE INDEX ?
How will u optimize query?
Ex: it will take 1 hours, but we need it in 20 min ?
Difference b/w DESCRIBE and Explain ?
What is horizontal partition?
Steps for migrating from mysql 4 to myqsl 5?
What is the difference between left join, inner join , Cross join?
cross join : records in table 1 * records in table 1