imported>InternetArchiveBot：补救9个来源，并将0个来源标记为失效。) #IABot (v2.0.8.6

2022-01-22T07:51:46Z

补救9个来源，并将0个来源标记为失效。) #IABot (v2.0.8.6

新页面

{{Infobox software
| name = MyRocks
| logo =
| logo size = 200px
| logo alt =
| logo caption =
| developer = [[脸书公司]]
| released = {{Start date and age|2015}}
| discontinued = 
| ver layout = 
| latest release version =
| latest release date = {{Start date and age|2016}}
| programming language = [[C++]]
| operating system =
| platform =
| genre = [[数据库引擎]]
| license = [[GNU通用公共许可证|GPL]] 2.0
| website = {{URL|http://myrocks.io/}}
| repo = {{URL|https://github.com/facebook/mysql-5.6}}
}}

'''MyRocks'''是在[[Facebook]]开发的[[开源软件]]，目的是将[[MySQL]]的功能与[[RocksDB]]的实现结合起来。它是基于Oracle MySQL 5.6的。

从10.2.5版本开始，[[MariaDB]]将MyRocks作为一个alpha阶段的存储引擎。<ref>{{Cite news|url=https://mariadb.org/thoughts-mariadb-server-10-3-mariadb-developers-meeting-amsterdam-part-1/|title=Thoughts on MariaDB Server 10.3 from MariaDB Developers Meeting in Amsterdam, part 1 - MariaDB.org|date=2016-10-10|newspaper=MariaDB.org|language=en-US|access-date=2017-01-06|archive-date=2021-10-19|archive-url=https://web.archive.org/web/20211019215156/https://mariadb.org/thoughts-mariadb-server-10-3-mariadb-developers-meeting-amsterdam-part-1/|dead-url=no}}</ref><ref>{{Cite news|url=https://mariadb.com/kb/en/the-mariadb-library/mariadb-1025-release-notes/|title=MyRocks alpha storage engine added - MariaDB 10.2.5 Release Notes|date=2017-04-05|newspaper=MariaDB.org|language=en-US|access-date=2017-08-31|archive-date=2017-08-31|archive-url=https://web.archive.org/web/20170831174616/https://mariadb.com/kb/en/the-mariadb-library/mariadb-1025-release-notes/|dead-url=no}}</ref> MariaDB 10.3.7把MyRocks作为一个存储引擎。<ref>{{Cite news|url=https://mariadb.com/kb/en/library/mariadb-1034-release-notes/|title=MariaDB 10.3.4 Release Notes|date=2018-01-18|newspaper=MariaDB.com|language=en-US|access-date=2018-01-19|archive-date=2018-01-26|archive-url=https://web.archive.org/web/20180126182338/https://mariadb.com/kb/en/library/mariadb-1034-release-notes/|dead-url=no}}</ref> MyRocks也支持Percona服务器。

该库由Facebook数据库工程团队维护。

== 特性 ==
RocksDB针对快速、低延迟的存储进行了优化，而MyRocks则旨在保持存储的高效性。

MyRock的效率集中在更高的空间效率、写入效率和读取效率上。<ref name=":0">{{Cite web|url=https://code.facebook.com/posts/190251048047090/myrocks-a-space-and-write-optimized-mysql-database/|title=MyRocks: A space- and write-optimized MySQL database|website=Facebook Code|access-date=2017-01-06|date=2016-08-31|archive-date=2020-11-08|archive-url=https://web.archive.org/web/20201108162322/https://code.facebook.com/posts/190251048047090/myrocks-a-space-and-write-optimized-mysql-database/|dead-url=no}}</ref>
* 更高的空间效率意味着使用更少的SSD存储。
* 更高的写入效率意味着SSD用得更久。
* 更高的读取效率来自于有更多可用IO容量可以用来处理查询。

== 基准测试 ==
针对3个不同实例的基准测试--MyRocks（压缩）、[[InnoDB]]（未压缩）和InnoDB（压缩，8KB页面大小），发现：<ref name=":0" />
* MyRocks比InnoDB（压缩）小2倍，比InnoDB（未压缩）小3.5倍。
* 与InnoDB相比，MyRocks的存储写入率也降低了10倍。

有了SSD数据库存储，随着时间的推移，使用的空间更少，存储的耐用性更高。

== 支持的平台 ==
官方支持的平台子集是：
* CentOS 6.8
* CentOS 7.2.x
用于验证构建的编译器工具集：
* gcc 4.8.1
* gcc 4.9.0
* gcc 5.4.0
* gcc 6.1.0
* Clang 3.9.0
尽最大努力支持以下操作系统：
* Ubuntu 14.04.4 LTS
* Ubuntu 15.10
* Ubuntu 16.04 LTS

== 参见 ==
* [[RocksDB]]
* [[MySQL数据库引擎的比较]]

== 参考文献 ==
{{Reflist}}

== 外部链接 ==
* [http://myrocks.io/ 官方网站] {{Wayback|url=http://myrocks.io/ |date=20211011080208 }}
* [https://github.com/facebook/mysql-5.6 源代码仓库] {{Wayback|url=https://github.com/facebook/mysql-5.6 |date=20191115092113 }}
* [https://groups.google.com/forum/#!forum/myrocks-dev MyRocks用户邮件列表] {{Webarchive|url=http://arquivo.pt/wayback/20110122130054/https://groups.google.com/forum/#!forum/myrocks-dev |date=2011-01-22 }}
* [https://github.com/facebook/mysql-5.6/wiki 文档wiki] {{Wayback|url=https://github.com/facebook/mysql-5.6/wiki |date=20211018111022 }}
* [https://mariadb.com/kb/en/myrocks/ MariaDB文档中的MyRocks] {{Wayback|url=https://mariadb.com/kb/en/myrocks/ |date=20210901154645 }}

{{Facebook navbox}}

[[Category:MySQL]]
[[Category:数据库引擎]]
[[Category:Facebook軟體]]
[[Category:自由软件]]

MyRocks - 版本历史

imported>InternetArchiveBot：​补救9个来源，并将0个来源标记为失效。) #IABot (v2.0.8.6

imported>InternetArchiveBot：补救9个来源，并将0个来源标记为失效。) #IABot (v2.0.8.6