Skip to content

Instantly share code, notes, and snippets.

@henryoswald
Created June 6, 2017 16:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save henryoswald/972fdaa2f6eb6f9da72c720cc4ddf850 to your computer and use it in GitHub Desktop.
Save henryoswald/972fdaa2f6eb6f9da72c720cc4ddf850 to your computer and use it in GitHub Desktop.
profile redis data with rdb tools
#!/bin/bash
rdb -c memory $1 > memory.csv
sort -t"," -n -k4 memory.csv > sorted.csv
grep -a "sess" sorted.csv> sess.csv
grep -a "DocsWithHistoryOps" sorted.csv > DocsWithHistoryOps.csv
grep -a "DocOps" sorted.csv > DocOps.csv
grep -a "doclines" sorted.csv > doclines.csv
grep -a "tpds" sorted.csv> tpds.csv
grep -a "UncompressedHistoryOps" sorted.csv> historyops.csv
grep -a "clients_in_project" sorted.csv> clients_in_project.csv
grep -a "Ranges" sorted.csv> Ranges.csv
grep -a "UserSessions" sorted.csv> UserSessions.csv
grep -a "RateLimit" sorted.csv> RateLimit.csv
grep -a "connected_user" sorted.csv> connected_user.csv
grep -a "password_token" sorted.csv> password_token.csv
grep -a "clsiserver" sorted.csv> clsiserver.csv
grep -a "DocHash" sorted.csv> DocHash.csv
grep -a "compile" sorted.csv> compile.csv
grep -a "Blocking" sorted.csv> Blocking.csv
grep -a "ProjectId" sorted.csv> ProjectId.csv
grep -a "SudoMode" sorted.csv> SudoMode.csv
grep -a "dropbox-poll-lock" sorted.csv> dropbox-poll-lock.csv
grep -a "DocVersion" sorted.csv> DocVersion.csv
grep -a "DocsIn" sorted.csv> DocsIn.csv
cat sorted.csv | grep -a -v "sess" | grep -a -v "DocOps" | grep -a -v "DocsWithHistoryOps" | grep -a -v "doclines" | grep -a -v "tpds" | grep -a -v "UncompressedHistoryOps" | grep -a -v "clients_in_project" | grep -a -v "Ranges" | grep -a -v "UserSessions" | grep -a -v "DocsIn" | grep -a -v "RateLimit" | grep -a -v "connected_user"| grep -a -v "password_token"| grep -a -v "clsiserver" | grep -a -v "DocHash"| grep -a -v "compile"| grep -a -v "Blocking"| grep -a -v "ProjectId"| grep -a -v "SudoMode"| grep -a -v "dropbox-poll-lock"|grep -a -v "DocVersion"> other.csv
echo "Sess :" && awk -F ',' '{ x = x + $4 } END { print x }' sess.csv
echo "DocsWithHistoryOps:" && awk -F ',' '{ x = x + $4 } END { print x }' DocsWithHistoryOps.csv
echo "Docops:" && awk -F ',' '{ x = x + $4 } END { print x }' DocOps.csv
echo "Doclines:" && awk -F ',' '{ x = x + $4 } END { print x }' doclines.csv
echo "tpds :" && awk -F ',' '{ x = x + $4 } END { print x }' tpds.csv
echo "historyops :" && awk -F ',' '{ x = x + $4 } END { print x }' historyops.csv
echo "clients_in_project:" && awk -F ',' '{ x = x + $4 } END { print x }' clients_in_project.csv
echo "Ranges:" && awk -F ',' '{ x = x + $4 } END { print x }' Ranges.csv
echo "UserSessions:" && awk -F ',' '{ x = x + $4 } END { print x }' UserSessions.csv
echo "DocsIn:" && awk -F ',' '{ x = x + $4 } END { print x }' DocsIn.csv
echo "RateLimit:" && awk -F ',' '{ x = x + $4 } END { print x }' RateLimit.csv
echo "connected_user:" && awk -F ',' '{ x = x + $4 } END { print x }' connected_user.csv
echo "password_token:" && awk -F ',' '{ x = x + $4 } END { print x }' password_token.csv
echo "clsiserver:" && awk -F ',' '{ x = x + $4 } END { print x }' clsiserver.csv
echo "DocHash:" && awk -F ',' '{ x = x + $4 } END { print x }' DocHash.csv
echo "compile:" && awk -F ',' '{ x = x + $4 } END { print x }' compile.csv
echo "Blocking:" && awk -F ',' '{ x = x + $4 } END { print x }' Blocking.csv
echo "ProjectId:" && awk -F ',' '{ x = x + $4 } END { print x }' ProjectId.csv
echo "SudoMode:" && awk -F ',' '{ x = x + $4 } END { print x }' SudoMode.csv
echo "dropbox-poll-lock:" && awk -F ',' '{ x = x + $4 } END { print x }' dropbox-poll-lock.csv
echo "DocVersion" && awk -F ',' '{ x = x + $4 } END { print x }' DocVersion.csv
echo "other:" && awk -F ',' '{ x = x + $4 } END { print x }' other.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment