J u m p t o c o n t e n t
M a i n m e n u
M a i n m e n u
N a v i g a t i o n
● M a i n p a g e ● C o n t e n t s ● C u r r e n t e v e n t s ● R a n d o m a r t i c l e ● A b o u t W i k i p e d i a ● C o n t a c t u s ● D o n a t e
C o n t r i b u t e
● H e l p ● L e a r n t o e d i t ● C o m m u n i t y p o r t a l ● R e c e n t c h a n g e s ● U p l o a d f i l e
S e a r c h
Search
A p p e a r a n c e
● C r e a t e a c c o u n t ● L o g i n
P e r s o n a l t o o l s
● C r e a t e a c c o u n t ● L o g i n
P a g e s f o r l o g g e d o u t e d i t o r s l e a r n m o r e ● C o n t r i b u t i o n s ● T a l k
( T o p )
1 F e a t u r e s
2 B e n c h m a r k s
3 S u p p o r t p l a t f o r m s
4 S e e a l s o
5 R e f e r e n c e s
6 E x t e r n a l l i n k s
T o g g l e t h e t a b l e o f c o n t e n t s
M y R o c k s
1 l a n g u a g e
● 中 文
E d i t l i n k s
● A r t i c l e ● T a l k
E n g l i s h
● R e a d ● E d i t ● V i e w h i s t o r y
T o o l s
T o o l s
A c t i o n s
● R e a d ● E d i t ● V i e w h i s t o r y
G e n e r a l
● W h a t l i n k s h e r e ● R e l a t e d c h a n g e s ● U p l o a d f i l e ● S p e c i a l p a g e s ● P e r m a n e n t l i n k ● P a g e i n f o r m a t i o n ● C i t e t h i s p a g e ● G e t s h o r t e n e d U R L ● D o w n l o a d Q R c o d e ● W i k i d a t a i t e m
P r i n t / e x p o r t
● D o w n l o a d a s P D F ● P r i n t a b l e v e r s i o n
A p p e a r a n c e
F r o m W i k i p e d i a , t h e f r e e e n c y c l o p e d i a
Starting from version 10.2.5, MariaDB includes MyRocks as an alpha-stage storage engine.[1] [2] [3] Percona 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.
[ edit ]
The officially supported subset of platforms are:
Compiler toolsets we verify our builds with:
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 ]
^ "MariaDB 10.3.4 Release Notes" . MariaDB.com . 2018-01-18. Retrieved 2018-01-19 .
^ a b "MyRocks: A space- and write-optimized MySQL database" . Facebook Code . 2016-08-31. Retrieved 2017-01-06 .
External links
[ edit ]
t
e
Products
People
Founders
Board
Executive
Oversight
Members
Board of
Former
Notable
Open source
Mass media
Concepts
Business
Lists
Related
R e t r i e v e d f r o m " https://en.wikipedia.org/w/index.php?title=MyRocks&oldid=1219700131 " C a t e g o r i e s : ● M y S Q L ● M a r i a D B ● B i g t a b l e i m p l e m e n t a t i o n s ● D a t a b a s e e n g i n e s ● F a c e b o o k s o f t w a r e ● F r e e s o f t w a r e p r o g r a m m e d i n C + + ● S o f t w a r e u s i n g t h e G P L l i c e n s e
● T h i s p a g e w a s l a s t e d i t e d o n 1 9 A p r i l 2 0 2 4 , a t 0 9 : 2 7 ( U T C ) . ● T e x t i s a v a i l a b l e u n d e r t h e C r e a t i v e C o m m o n s A t t r i b u t i o n - S h a r e A l i k e L i c e n s e 4 . 0 ;
a d d i t i o n a l t e r m s m a y a p p l y . B y u s i n g t h i s s i t e , y o u a g r e e t o t h e T e r m s o f U s e a n d P r i v a c y P o l i c y . W i k i p e d i a ® i s a r e g i s t e r e d t r a d e m a r k o f t h e W i k i m e d i a F o u n d a t i o n , I n c . , a n o n - p r o f i t o r g a n i z a t i o n . ● P r i v a c y p o l i c y ● A b o u t W i k i p e d i a ● D i s c l a i m e r s ● C o n t a c t W i k i p e d i a ● C o d e o f C o n d u c t ● D e v e l o p e r s ● S t a t i s t i c s ● C o o k i e s t a t e m e n t ● M o b i l e v i e w
