Shulou(Shulou.com)05/31 Report--

Editor to share with you what are the new features of MySQL6.0, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

* subqueries and Join are optimized, including bulk index access to the decentralized scope of the MyISAD and InnoB storage engines.

* added BACKUP DATABASE and RESTORE statements for backup and restore operations. See section 6.3, "backing up with MySQL".

* support more Unicode character sets: utf16, utf32, and 4-byte utf8. These character sets support these additional Unicode character sets, that is, characters that are outside the underlying multilingual base).

* New Falcon transaction storage engine (see 13.8, Falcon Storage engine).

* improve INFORMATION_SCHEMA and add INFORMATION_SCHEMA.PARAMETERS table, and INFORMATION_SCHEMA.ROUTINES add new columns (see INFORMATION_SCHEMAPARAMETERS Table 19.27 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 unmentioned table-level locks, and you can make sure that LOCK TABLES statements can get multiple transaction locks in succession, adding additional tables to the lock set without unlocking previously locked tables. When using LOCK TABLES with IN SHARE MODE or in EXCLUSIVE MODE, table-level locks are not unlocked until the end of the transaction. Transaction locks acquired using LOCK TABLE are released at the end of the transaction, including a displayed commit or rollback, an implicit commit due to a statement, or a link closure. 12.4.3, "statements that cause implicit commit", lists the statements that cause implicit commit. The behavior of LOCK TABLES is reported unchanged when READ and WRITE are locked (that is, when IN SHARE MODE or IN EXCLUSIVE MODE is not used).

* enhanced XML features, including a new LOAD XML syntax (see 12.2.7, "LOAD XML Syntax").

* support extended comments, including tables, columns and indexes. The following structure is obsolete and has been deleted in MySQL 6.0. Applications should be newer and use them in another way.

* table_type system variable (in storage_engine).

* the table is used in the TYPE parameter of CREATE TABEl or ALTER TABLE (using ENGINE).

* SHOW TABLE TYPES syntax (using SHOW ENGINES).

* The-- master-xxx specifies the server parameter of the replicated parameter (use CHANGE MASTER TO 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

* The log_bin_trust_routine_creators variable (using log_bin_trust_function_creators).

* TIMESTAMP (N): to specify a display width of N (use those without 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 (using SHOW PLUGINS).

* BACKUP TABLE and RESTORE TABLE syntax

These are all the contents of the article "what are the new features of MySQL6.0?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.