Showing posts with label large. Show all posts
Showing posts with label large. Show all posts

Tuesday, June 14, 2011

Useful Commands for Disk Cleanup

Top 20 Largest Files/Folders
du -m --max-depth=4 / | sort -nr | head -n 20

Lists all directories over 1GB
du -h / | grep ^[0-9.]*G


File and Folder Sizes from Current directory
(du -x -s * | sort -n -k1 ) 2>/dev/null

SQL Query - Show Large Tables

SELECT CONCAT(table_schema, '.', table_name),
       CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
       CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
       CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')idx,
       CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
       ROUND(index_length / data_length, 2) idxfrac
FROM   information_schema.TABLES
ORDER  BY data_length + index_length DESC
LIMIT  10;