MyRocks Table Engine for MySQL
summary
MyRocks is a storage engine for MySQL developed to reduce write amplification and storage cost when using flash (SSD) devices. It replaces MySQL’s default B-tree on-disk format with an LSM-tree design (RocksDB) to improve performance and efficiency on flash storage at Facebook scale.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 7:39How MyRocks stores data
- 10:29Log-structured merge trees
- 15:01Compaction strategies
- 21:49RocksDB integration
- 24:35How to try MyRocks
- 29:55Configuration and tuning
- 30:17Instant backup
- 32:52Reverse scanning and bloom filters
- 36:25Tombstones and compaction
- 37:28Limitations and future
- 38:32Conclusion
- 39:59Q&A
related talks
12mMyRocks at Facebook and a Roadmap
27mMyRocks: best practice at Alibaba - MySQL Storage Engine
51mMyRocks deep dive and production deployment at Facebook
57mRocksDB
52mRocksDB Performance and Reliability Practics
50mInnoDB to MyRocks Migration in Main MySQL Database
47mLessons Learned from Our Main Database Migrations at Facebook
29mAccelerating Performance: Mastering RocksDB for High Speed Data Processing