MySQL and PostgreSQL database

The MySQL database has become the world's most popular open source  database because of its high performance, high reliability and ease of use. 

1. It has 2 layers upper SQLlayer and set of storage engines
2. The most commonly used storage engines in MySQL are InnoDB for ACID support and higher performance on large workloads
3. It provides concurrency and MyISAM for Concurrency workloads.
4. It has been developed with a focus on speed
5. It supports 9 storage engines

• MyISAM
• InnoDB
• NDB Cluster
• MERGE
• MEMORY (HEAP)
• FEDERATED
• ARCHIVE
• CSV

It is also the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.) Many of the world's largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.

The latest version available in the market can be downloaded to go to downloaded by clicking here

1. It has been developed from developers who came from an oracle or SQL server backgreoun.
2. Powerful for object relational database systems.
3. Runs on all Operating Systems.
4. Nativeprogramming interfaces for C/C++,Java,Tcl,Ruby etc.,
5. It boasts features like Multi-Version Concurreny Control(MVCC).
6. It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels.
7. GiST (Generalized Search Tree) indexing is an advanced system which brings together a wide array of different sorting and searching algorithms including B-tree, B+-tree, R-tree, partial sum trees, ranked B+-trees and many others. It also provides an interface which allows both the creation of custom data types as well as extensible query methods with which to search them. 



Some general Limits



The latest version available in the market can be downloaded to go to downloaded by clicking here