Some Diagnostic Shortcuts

shortcuts.txt

# Proper tree view of directories (Bash)
ls -R | grep ":$" | sed -e 's/:$//' -e 's/[^-][^\/]*\//--/g' -e 's/^/   /' -e 's/-/|/' 

# Database table sizes (MySQL, MB)
SELECT SUM(data_length / (1024 * 1024)), table_schema, table_name Data_MB FROM information_schema.tables WHERE table_schema NOT IN ('information_schema','performance_schema','mysql') GROUP BY table_schema, table_name;