TheMySQL6.0goodybag_MySQL

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了TheMySQL6.0goodybag_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2122字，纯文字阅读大概需要4分钟。

内容图文

After MySQL 5.1 was released work started on MySQL 5.2, but then this was renamed to MySQL 6.0. There were many new features introduced in 6.0. But then stabilizing this branch became as huge task. Eventually the decision was made to start of with a stable branch and backport the new features from 6.0. This is how many of the 6.0 features landed in 5.5 and 5.6.

So let's see which features 6.0 brought and were they landed. I'll use theWhat Is New in MySQL 6.0section of theMySQL 6.0 Reference Manualfor this.

• The Falcon storage engine. This never landed anywhere as far as I know. It's not even included in thelist of storage enginesin the MariaDB knowledgbase. As both InnoDB and MySQL are now part of Oracle I don't see any reason for Falcon to exist anymore.
• 4-byte utf8 and support for utf16 and utf32. This is included in MySQL 5.5 together with many other Unicode enhancements.
• Database backup with SQL. This allows you to make backups by executing 'BACKUP DATABASE' SQL statements. This is has not landed anywhere as far as I know, but some of the code might have made it into MySQL Enterprise Backup (both use backup_history and backup_progress tables in the mysql database). This might be an interesting thing to have, but with MEB there is not a real need for it.
• Subquery enhancements, BKA and MRR. This all made it into MySQL 5.6.
• LOAD XML. This made it into MySQL 5.5, but I don't think it is used often.
• The Maria storage engine. This is a transactional MyISAM storage egine. This is not used in Oracle MySQL. It is included in MariaDB, but renamed toAriaas it might otherwise cause confusion. As far as I known there is not much development being done on Aria.
• Foreign Keys. Of course MySQL supports foreign keys (now even with NDB!), but those are implemented in the storage engine, not in the server. This was on the roadmap for 6.x but I don't know if it was actually implemented. Implementing this in the server could make writing storage engines easier and would probably also make it easier to combine partitioning and foreign keys.

Did I forget any 6.x features? Did you ever try 6.x? Let me know in the comments!

内容总结

以上是互联网集市为您收集整理的TheMySQL6.0goodybag_MySQL全部内容，希望文章能够帮你解决TheMySQL6.0goodybag_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---