New features preview for MYSQL 6.0

* Subqueries and joins are optimized to include bulk index access within the decentralized range of the MYISAD and Innob storage engines.

* Added backup DATABASE and restore statements for backups and restores operations. See section 6.3, "Using MySQL backup".

* Support for more Unicode character sets: Utf16, UTF32, and 4-byte UTF8. These character sets support these additional Unicode character sets, which are those that are outside the base multi-language base.

* New Falcon Transaction storage engine (see 13.8, "Falcon Storage Engine").

* RESET Slave no longer changes the parameters of the replication connection; Previously, it reset the values they specified to the command line (see 12.6.2.3, "RESET slave Syntax").

* Improved INFORMATION_SCHEMA database and increased information_schema. PARAMETERS table, Information_schema. Routines added a new column (see section 19.27 "Information_schemaparameters table", and 19.14 ", Information_schema routines Routines table").

* Lock tables syntax has been extended to support transaction table locks that do not automatically commit transactions. In the back of the LOCK TABLES ... In SHARE MODE or LOCK TABLES ... In EXCLUSIVE MODE you can use a table-level lock that is not mentioned, and you can also make sure that the lock tables can get multiple transaction locks in succession, adding extra tables to the lock collection without unlocking the previously locked tables. Table-level locks are not unlocked until the end of a transaction when using lock tables with in SHARE mode or EXCLUSIVE mode. A transaction lock obtained using lock table is released at the end of a transaction, including a displayed commit or rollback, either because of an implicit commit caused by the statement, or because the link is closed. 12.4.3, "causes an implicit commit statement", lists those statements that cause an implicit commit. The behavior of lock tables is invariant in the read and write lock times (that is, when you do not use in SHARE mode or in EXCLUSIVE mode).

* Enhanced XML functionality, including a new load XML syntax (see 12.2.7, "LOAD XML Syntax").

* Supports extended annotations, including tables, columns, and indexes. The following structure is obsolete and has been removed in MySQL 6.0. Applications should follow new and use them in another way.

* Table_type System variables (with Storage_engine).

* The TYPE parameter of the form used for the Create Tabel or ALTER table (using engine).

* Show TABLE TYPES syntax (using show engines).

* The--master-xxx specifies the server parameters for the copied parameters (using the Change master to statement instead):

--master-host,--master-user,--master-password,--master-port,--master-connect-retry,--master-ssl,--master-ssl-c A,--master-ssl-capath,--master-ssl-cert,--master-ssl-cipher,--master-ssl-key

* The log_bin_trust_routine_creators variable (using log_bin_trust_function_creators).

* TIMESTAMP (N): To specify a display width of n (using no n).

* Show INNODB status and show MUTEX status syntax (using show ENGINE INNODB status).

* The LOAD TABLE ... From Master and LOAD DATA from master syntax.

* Show PLUGIN syntax (use show PLUGINS).

* BACKUP table and RESTORE table syntax