Both MyRocks (MySql) and Cassandra uses LSM architecture to store their data. So I have populated around 5 million rows in MySql with MyRocks as storage engine and also in Cassandra. In Cassandra it takes only 1.7 GB of disk space while in MySql with MyRocks as storage engine, takes 19 GB.
Am I missing something? Both uses same LSM mechanism. But why they differ in data size? Can someone please explain?
And an update to the above question. I guess it has something to do with the text column.
- Tried with another Table Structure : (bigint,bigint,varchar,text).
- No Of rows Populated : 300 000
- Now in MyRocks the data size is 185MB
- In Cassandra - 13 MB.
But if I remove the text column then,
- MyRocks - 21.6 MB
- Cassandra - 11 MB
Any idea about this behaviour?