Regarding the compaction I would still love to hear your feedback on how to configure Cassandra accordingly.
I found a patch for the php extension here:
… this seemed to fix the issue. Thank you Jonathan and Aaron for taking time to provide me with some help!Here are my facts again:Data size on disk: ~1GBData Volume: ~150GB free storageOS Volume: ~3GB free storageTried:nodetool --host localhost compactThe logfiles said:2011/6/5 Mario Micklisch <email@example.com>
I tracked down the timestamp submission and everything was fine within the PHP Libraries.
The thrift php extension however seems to have an overflow, because it was now setting now timestamps with also negative values ( -1242277493 ). I disabled the php extension and as a result I now got correct microsecond timestamps: 1307270937122897
I was using the latest version from http://www.apache.org/dist/thrift/0.6.1/ to build the extension without using any special parameters (just ./configure --enable-gen-php=yes and make install).
Downloaded and re-compiled it, without any change. I can also see no compile parameters to set which might help.
Any advise where to go from here?
Thanks so far!