GnuDeveloper.com

MySQL

Key Difference between MySQL 5.0 vs MySQL 5.1

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.

Table Partition:

we can partition table when creating table. If needed we can also create sub partition too.
2 Types:

Support for Character Sets and Collations in MySQL DB.

The Things we have to consider
1. Database Level Collation Type
2. Table Level Collation Type
3. Fields Level Collation Type

Mysql Interview Questions

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