Major features as available in MySQL 5.6: A broad subset of ANSI SQL 99, as well as extensions Cross-platform support Stored procedures, using a procedural language that closely adheres to SQL/PSM Triggers Cursors Updatable views Online Data Definition Language (DDL) when using the InnoDB Storage Engine. Information schema Performance Schema that collects and aggregates statistics about server execution and query performance for monitoring purposes. A set of SQL Mode options to control runtime behavior, including a strict mode to better adhere to SQL standards. X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using the default InnoDB storage engine Transactions with savepoints when using the default InnoDB Storage Engine. The NDB Cluster Storage Engine also supports transactions. ACID compliance when using InnoDB and NDB Cluster Storage Engines SSL support Query caching Sub-SELECTs (i.e. nested SELECTs) Built-in replication support Asynchronous replication: master-slave from one master to many slaves or many masters to one slave Semi synchronous replication: Master to slave replication where the master waits on replication Synchronous replication: Multi-master replication is provided in MySQL Cluster. Virtual Synchronous: Self managed groups of MySQL servers with multi master support can be done using: Galera Cluster or the built in Group Replication plugin Full-text indexing and searching Embedded database library Unicode support Partitioned tables with pruning of partitions in optimizer Shared-nothing clustering through MySQL Cluster Multiple storage engines, allowing one to choose the one that is most effective for each table in the application. Native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated, Archive, CSV, Blackhole, NDB Cluster. Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.
Major features as available in MySQL 5.6: A broad subset of ANSI SQL 99, as well as extensions Cross-platform support Stored procedures, using a procedural language that closely adheres to SQL/PSM Triggers Cursors Updatable views Online Data Definition Language (DDL) when using the InnoDB Storage Engine. Information schema Performance Schema that collects and aggregates statistics about server execution and query performance for monitoring purposes. A set of SQL Mode options to control runtime behavior, including a strict mode to better adhere to SQL standards. X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using the default InnoDB storage engine Transactions with savepoints when using the default InnoDB Storage Engine. The NDB Cluster Storage Engine also supports transactions. ACID compliance when using InnoDB and NDB Cluster Storage Engines SSL support Query caching Sub-SELECTs (i.e. nested SELECTs) Built-in replication support Asynchronous replication: master-slave from one master to many slaves or many masters to one slave Semi synchronous replication: Master to slave replication where the master waits on replication Synchronous replication: Multi-master replication is provided in MySQL Cluster. Virtual Synchronous: Self managed groups of MySQL servers with multi master support can be done using: Galera Cluster or the built in Group Replication plugin Full-text indexing and searching Embedded database library Unicode support Partitioned tables with pruning of partitions in optimizer Shared-nothing clustering through MySQL Cluster Multiple storage engines, allowing one to choose the one that is most effective for each table in the application. Native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated, Archive, CSV, Blackhole, NDB Cluster. Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.