MySQL is a multithreaded, multi-user, SQL Database Management System (DBMS).
Features:
ACID compliance using the InnoDB, BDB and Cluster engines
Shared-nothing clustering through MySQL Cluster
Embedded database library
Full Unicode support
Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
Full-text indexing and searching using MyISAM engine
Query caching
Sub-SELECTs (i.e. nested SELECTs)
Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB
SSL support
Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, Archive for storing historical data in little space)Strict mode
X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine
True VARCHAR support
INFORMATION_SCHEMA
Cursors
updatable Views
Stored procedures
Triggers
A broad subset of ANSI SQL 99, as well as extensions
Cross-platform support
0 comments:
Post a Comment