Movatterモバイル変換


[0]ホーム

URL:


Jump to content
WikipediaThe Free Encyclopedia
Search

MyRocks

From Wikipedia, the free encyclopedia
MyRocks
DeveloperFacebook, Inc.
Initial release2015; 10 years ago (2015)
Repositorygithub.com/facebook/mysql-5.6
Written inC++
TypeDatabase engine
LicenseGPL 2.0
Websitemyrocks.io

MyRocks isopen-source software developed atFacebook in order to useMySQL features withRocksDB implementations. It is based on Oracle MySQL 5.6.

Starting from version 10.2.5,MariaDB includes MyRocks as an alpha-stage storage engine.[1][2] MariaDB 10.3.7 includes MyRocks as a storage engine.[3] MyRocks is also shipped withPercona Server.

The library is maintained by the Facebook Database Engineering Team.

Features

[edit]

RocksDB is optimized for fast, low-latency storage, and MyRocks is aimed at keeping the storage savings efficient.

MyRock's efficiency focuses on better space efficiency, better write efficiency, and better read efficiency.[4]

  • Better space efficiency means using less SSD storage.
  • Better write efficiency means SSD endurance.
  • Better read efficiency comes from more available IO capacity for handling queries.

Benchmarks

[edit]

Benchmark tests against 3 different instances – MyRocks (compressed),InnoDB (uncompressed), and InnoDB (compressed, 8 KB page size) – found:[4]

  • MyRocks was 2x smaller than InnoDB (compressed) and 3.5x smaller than InnoDB (uncompressed).
  • MyRocks also has a 10x lower storage write rate compared to InnoDB.

With SSD database storage, this means less space used and a higher endurance of the storage over time.

Support platforms

[edit]

Per the MyRocks documentation:[5]

The officially supported subset of platforms are:

  • CentOS 6.8
  • CentOS 7.2.x

Compiler toolsets with which the builds are verified:

  • gcc 4.8.1
  • gcc 4.9.0
  • gcc 5.4.0
  • gcc 6.1.0
  • Clang 3.9.0

Best effort is made to support the following OSs:

  • Ubuntu 14.04.4 LTS
  • Ubuntu 15.10
  • Ubuntu 16.04 LTS

See also

[edit]

References

[edit]
  1. ^"Thoughts on MariaDB Server 10.3 from MariaDB Developers Meeting in Amsterdam, part 1 - MariaDB.org".MariaDB.org. 2016-10-10. Retrieved2017-01-06.
  2. ^"MyRocks alpha storage engine added - MariaDB 10.2.5 Release Notes".MariaDB.org. 2017-04-05. Retrieved2017-08-31.
  3. ^"MariaDB 10.3.4 Release Notes".MariaDB.com. 2018-01-18. Retrieved2018-01-19.
  4. ^ab"MyRocks: A space- and write-optimized MySQL database".Facebook Code. 2016-08-31. Retrieved2017-01-06.
  5. ^"MyRocks: Getting Started: Supported Platforms".MyRocks. Retrieved2025-05-15.

External links

[edit]
Editions
SQL GUI tools
Storage engines
Procedural Language
Forks and Branches
Products
and services
Facebook
Instagram
Hardware
Other
Former
People
Founders
Board
Current
Former
Executive
officers
Current
Former
Oversight
Board
Members
Board of
Trustees
Former
members
Notable
employees
Current
Former
Open source
Mass media
Concepts
Business
Lists
Related
Retrieved from "https://en.wikipedia.org/w/index.php?title=MyRocks&oldid=1291114899"
Categories:

[8]ページ先頭

©2009-2025 Movatter.jp