Handy shell snippet

Show the most-often-hit URLs from a squid proxy log:

tail -10000 access.log | awk '/GET.*DIRECT/ { i[$7]++;}; END{for (a in i) { if (i[a] > 100) printf("%-7s %s\n", i[a], a); }}' | sort -n