Re: The size of the data, I must be doing smth wrong....

2011-01-05 Thread Edward Capriolo
On Wed, Jan 5, 2011 at 9:52 AM, Jonathan Ellis wrote: > It's normal for Cassandra to use more disk space than MySQL.  It's > part of what we trade for not having to rewrite every row when you add > a new column. > > "SSTables that are obsoleted by a compaction are deleted > asynchronously when the

Re: The size of the data, I must be doing smth wrong....

2011-01-05 Thread Jonathan Ellis
It's normal for Cassandra to use more disk space than MySQL. It's part of what we trade for not having to rewrite every row when you add a new column. "SSTables that are obsoleted by a compaction are deleted asynchronously when the JVM performs a GC." http://wiki.apache.org/cassandra/MemtableSSTa

The size of the data, I must be doing smth wrong....

2011-01-05 Thread nicolas lattuada
Hi i have some data size issues: i am storing super columns with the following content: {a=>1, b=>2, c=>3...n=>14} i am storing it 300 000 times and i have a data size on the disk about 283Mo And in other side i have a mysql table which stores a bunch of data the schema follows: 6 varch