Getting total memtables size in Cassandra

Ever wanted to know the total size of the memtables in your Cassandra cluster? Here is a little oneliner which gets you the total size in bytes.

nodetool cfstats | grep 'Memtable Data Size' | awk '{sum+=$4}END{print sum}'

view raw memtable_size.sh hosted with ❤ by GitHub

Remember SSH Passphrase in Cygwin

I found it annoying that Cygwin asks for the passphrase of your private ssh key every time you are starting a ssh connection. In the regular bash shell under Ubuntu it would remember the passphrase so it only needs to be entered once. Here is a nice recipe that helps Cygwin remembering the passphrase (thanks to this blogpost). In your ~/.bash_profile add the following at the end:

	if [ -f ${HOME}/.ssh-agent ]; then
	. ${HOME}/.ssh-agent > /dev/null
	fi
	if [ -z "$SSH_AGENT_PID" -o -z "`/usr/bin/ps -a|/usr/bin/egrep \"^[ ]+$SSH_AGENT_PID\"`" ]; then
	/usr/bin/ssh-agent > ${HOME}/.ssh-agent
	. ${HOME}/.ssh-agent > /dev/null
	fi
	ssh-add ~/.ssh/id_rsa

view raw cygwin_passphrase.sh hosted with ❤ by GitHub