Peter Sylvester wrote this blog post about new storage engine for MySQL that’s rising in popularity. MyRocks, the log-structured merge-driven RocksDB engine in MySQL.
The content is split into:
- Rows vs. key-value
- Column families
- System variables vs. column family options
- In-Memory data writes
- Variables and CF_OPTIONS
- Associated Metrics
In this post, you get column families explained, the differences between server variables and column family options, how data gets written into memory space, the associated logging, and different conditions that designate when that data will be flushed to disk. Good read!
[Read More]