MySQLOnRocksDB/mysql-5.6
forked from facebook/mysql-5.6

Loading…
Needs more space efficient row checksums #93
Closed
yoshinorim opened this Issue
· 1 comment
Owner
yoshinorim
commented
Owner
yoshinorim
commented
Introducing rocksdb_checksums_pct variable -- https://reviews.facebook.net/D43419
I'll keep this issue opened until we figure out if CRC8|16 are needed.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Here are sizes of loading LinkBench data with 1.5B max ids.
Without row checksum: 570959236
With row checksum enabled: 705439184
23.6% space increase is too much. This was because current row checksum adds 9 bytes (1B + CRC32 key and CRC32 value) into value for each index entry.
How about doing some optimizations like below?