The new Falcon transactional storage engine (see Section 13.6, “The Falcon Storage Engine”).

Support for additional Unicode character sets: utf16, utf32, and 4-byte utf8. These character sets support supplementary Unicode characters; that is, characters outside the Basic Multilingual Plane (BMP).

BACKUP DATABASE and RESTORE statements for backup and restore operations. See Section 6.3, “Using BACKUP DATABASE and RESTORE”.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related MySQL Links Downloads common doc downloads guilds img programs sources support tech-resources user-groups usingmysql workbench Request more information about Pantek

Improvements in the INFORMATION_SCHEMA database, with the addition of the INFORMATION_SCHEMA.PARAMETERS table, and new columns added to INFORMATION_SCHEMA.ROUTINES (see Section 25.26, “The INFORMATION_SCHEMA PARAMETERS Table”, and Section 25.14, “The INFORMATION_SCHEMA ROUTINES Table”).

Optimizer enhancements for faster subqueries and joins, including batched index access of table rows for sequences of disjoint ranges by the MyISAM and InnoDB storage engines.

RESET SLAVE no longer changes replication connection parameters; previously, it reset them to the values specified on the command line (see Section 12.6.2.3, “RESET SLAVE Syntax”).

The syntax for the LOCK TABLES statement has been extended to support transactional table locks that do not commit transactions automatically. Following LOCK TABLES ... IN SHARE MODE or LOCK TABLES ... IN EXCLUSIVE MODE, you can access tables not mentioned in the LOCK TABLES statement. You can also issue LOCK TABLES statements that acquire transactional locks many times in succession, adding additional tables to the locked set, and without unlocking any tables that were locked previously. When using LOCK TABLES with IN SHARE MODE or IN EXCLUSIVE MODE, tables are not unlocked until the transaction ends.

Transactional locks acquired with LOCK TABLES are released when the transaction ends, either explicitly with COMMIT or ROLLBACK, or implicitly due to a statement that causes implicit commit or because the connection ends. Section 12.4.3, “Statements That Cause an Implicit Commit”, lists those statements that cause implicit commit.

The behavior of LOCK TABLES remains unchanged for READ or WRITE locks (that is, when not using IN SHARE MODE or IN EXCLUSIVE MODE).

Enhancements to XML functionality, including a new LOAD XML statement (see Section 12.2.6, “LOAD XML Syntax”).

Support for extended comments for tables, columns, and indexes.

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related MySQL Links Downloads common doc downloads guilds img programs sources support tech-resources user-groups usingmysql workbench Request more information about Pantek

Replication conflict detection and resolution (see MySQL Cluster Replication Conflict Resolution).

Online ADD COLUMN, ADD INDEX, and DROP INDEX operations (see Section 12.1.10, “CREATE TABLE Syntax”, and Section 12.1.4, “ALTER TABLE Syntax”).

Batch operations, resulting in significant speed improvements (see the description of the new --slave-allow-batching option for mysqld in Section 5.1.2, “Command Options”).

Replication heartbeats, which enable real-time detection of replication failures and real-time failover (see Section 12.6.2.1, “CHANGE MASTER TO Syntax” for information about the new MASTER_HEARTBEAT_PERIOD option for this statement, as well as the descriptions of the associated Slave_heartbeat_period and Slave_received_heartbeats status variables).

The ability to bind client applications and replication slaves to specific network interfaces using the new --bind-address option (see the portions of Cluster Utility Programs covering the MySQL Cluster applications to which this applies; see Section 5.1.2, “Command Options” for information about how this option can be used with mysqld).

Enhancements to take advantage of real-time scheduling and to bind processes to specific CPUs on data node hosts having multiple processors (see Realtime Performance Parameters and Data Node Configuration Parameters).

The NDB API supports a new NdbRecord interface (see The NdbRecord Interface).

Can we help you?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related MySQL Links Downloads common doc downloads guilds img programs sources support tech-resources user-groups usingmysql workbench Request more information about Pantek

The ability to use multiple cluster connections in mysqld using the --ndb-cluster-connection-pool option.

Backup status reporting.

The table_type system variable (use storage_engine).

The TYPE table option to specify the storage engine for CREATE TABLE or ALTER TABLE (use ENGINE).

The SHOW TABLE TYPES SQL statement (use SHOW ENGINES).

The log_bin_trust_routine_creators variable (use log_bin_trust_function_creators).

Can't find what you're looking for?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related MySQL Links Downloads common doc downloads guilds img programs sources support tech-resources user-groups usingmysql workbench Request more information about Pantek

TIMESTAMP(N): The ability to specify a display width of N (use without N).

The SHOW INNODB STATUS and SHOW MUTEX STATUS SQL statements (use SHOW ENGINE INNODB STATUS for both of these).

The LOAD TABLE ... FROM MASTER and LOAD DATA FROM MASTER SQL statements.

The SHOW PLUGIN SQL statement (use SHOW PLUGINS).

The BACKUP TABLE and The RESTORE TABLE SQL statements.

The --master-xxx server options to set replication parameters (use the CHANGE MASTER statement instead): --master-host, --master-user, --master-password , --master-port, --master-connect-retry, --master-ssl, --master-ssl-ca, --master-ssl-capath, --master-ssl-cert, --master-ssl-cipher, --master-ssl-key.