MySQL is pofessional multithreaded multiuser open source SQL based database. It is developed and owned by single European company MySQL AB. It is considered to be one of the fastest, light and easy-to-pick-up databases. It alos has number of APIs for all popular languages and s closely tied to the popularity of PHP. This made MySQL the most popular database for web enviroment.
MySQL operates with multiple storage engines:
Such a varaity lets you to choose the one which is most effective for each table in the application.
MySQL features a broad subset of ANSI SQL 99, as well as extensions, Cross-platform support, Stored procedures, Triggers, Cursors, Updatable Views, True VARCHAR support, INFORMATION_SCHEMA, Strict mode, Distributed transaction processing (DTP) support (two phase commit as part of this, using Oracle's InnoDB engine), Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, Archive for storing historical data in little space), Transactions with the InnoDB, BDB and Cluster storage engines (savepoints with InnoDB), SSL support, Query caching, Sub-SELECTs (i.e. nested SELECTs), Replication with one master per slave and many slaves per master, Full-text indexing and searching using MyISAM engine, Embedded database library, Partial Unicode support (UTF-8 sequences longer than 3 bytes are not supported; UCS-2 encoded strings are also limited to the BMP), ACID compliance using the InnoDB, BDB and Cluster engines, Shared-nothing clustering through MySQL Cluster and much more.
The following pages will explain you: