New Features of MySQL6.0

* The subquery and Join operations are optimized, including Batch index access in the scattered regions of MyISAD and InnoB storage engines.

* The backup database and RESTORE statements are added for BACKUP and restoration. For details, see section 6.3 "using MySQL BACKUP ".

* Supports more Unicode character sets: utf16, utf32, and 4-byte utf8. These character sets support these additional Unicode character sets, that is, those beyond the base of a basic multilingual language ).

* The New Falcon transaction storage engine (see "Falcon storage engine" in "13.8 ").

* Reset slave no longer changes the replication connection parameters. Previously, it RESET them to the value specified by the command line (see section 12.6.2.3, "reset slave Syntax ").

* The INFORMATION_SCHEMA database is improved, and the INFORMATION_SCHEMA.PARAMETERS table is added. For details, see INFORMATION_SCHEMAPARAMETERS table in section 19.27, and INFORMATION_SCHEMA ROUTINES table in section 19.14 ").

* The lock tables syntax has been extended and supports transaction table locks that are not automatically committed by transactions. Lock tables... in share mode or lock tables... in exclusive mode you can use a table-Level LOCK that is not mentioned. You can also ensure that the lock tables statement can continuously obtain multiple transaction locks and add additional TABLES to the LOCK set, instead of unlocking a previously locked table. When lock tables with in share mode or exclusive mode is used, table-level locks are not unlocked before the transaction ends. The transaction LOCK obtained using the lock table is released at the end of the transaction, including the displayed commit or rollback, implicit commit caused by the statement, or closed due to the link. 12.4.3, "statements that cause implicit commit", lists the statements that cause implicit commit. The behavior of lock tables remains unchanged IN the READ and WRITE locks (that is, when the in share mode or in exclusive mode is not used ).

* The enhanced XML function includes a new load xml syntax (see section 12.2.7, "load xml Syntax ").

* Supports extended annotations, including tables, columns, and indexes. The following structure is outdated and has been deleted in MySQL 6.0. The application should be new and use them in another way.

* Table_type system variable (storage_engine ).

* The TYPE parameter used for TABLE creation in TABEl or alter table (using ENGINE ).

* Show table types syntax (use show engines ).

* The -- master-xxx specifies The server parameter of The copied parameter (replace it with change master to statement ):
-- 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

* The log_bin_trust_routine_creators variable (use log_bin_trust_function_creators ).

* TIMESTAMP (N): to specify the display width as N (N is not used ).

* Show innodb status and show mutex status syntax (use 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