cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Finke <>
Subject RE: Compacted_at timestamp
Date Mon, 09 Feb 2015 07:51:27 GMT
I created a small script recently converting this timestamp into a human readable string and
sort all entries ascending.

nodetool compactionhistory |awk '{timestamp = strftime("%a %b %e %H:%M:%S %Z %Y",$4 / 1000);in_m=$5/1024/1024;out_m=$6/1024/1024;
printf("%s\t%s\t%s\t%s\t%dM\t%dM\n",$4,timestamp,$2,$3,in_m,out_m)}' |sort -n

From: Mark Reddy []
Sent: 08 February 2015 21:55
Subject: Re: Compacted_at timestamp

Hi Santo,

If you are seeing the compacted_at value as timestamp and want to convert it to a human readable
date, this is not possible via nodetool. You will always write a script to make the compactionhistory
call and then convert the output (the fourth column - compacted_at) to a readable date.

If you are seeing something other than an expected timestamp value, can you post an example
of what you are getting?


On 8 February 2015 at 13:20, Havere Shanmukhappa, Santhosh <<>>
When I run nodetool compactionhistory command, it displays ‘compacted_at’ timestamp in
non-readable format. Any way to read that column in readable format? I am using c*2.0.11 version.


View raw message