Tuesday, January 12, 2010

Count number of files of certain size

find ./ -size 0k | grep "sess_" -c

This finds the files and directories matching a path and matching a size.
Can use -size +[number]k (above a certain size) or -size -[number]k (below a certain size), or a size match.
Then it pipes that to a grep for the word "sess_" and returns a count.
Helps us count the enormous number of blank sessions that our app is generating on OSX.

Friday, January 8, 2010

Selecting non-distinct rows in MySQL

Got this here.

SELECT *, COUNT(*) AS count FROM tablename GROUP BY fieldname HAVING count > 1