Skip to content

Rich Collier

global explorer, tech team lead, aviator, father, husband

  • Travel
    • 11,000 Miles
    • Camping Trip 2022
    • Six States Trip
    • My Travel Maps
  • Tech
  • Family
  • About me

Asides

Heading to the Floridamatticians Holiday Party

Road Trip

Port Saint Lucie, FL to Lakeland, FL
Author Rich CollierPosted on December 16, 2016December 20, 2016Format AsideCategories Automattic, TravelTags roadtripLeave a comment on Heading to the Floridamatticians Holiday Party

Get disk usage information for MySQL databases

Ever wonder how much space your MySQL database uses? Here you go:

SELECT table_schema "Database",
SUM( data_length + index_length ) / 1024 / 1024 "MB used",
SUM( data_free ) / 1024 / 1024 "MB free"
FROM information_schema.TABLES
GROUP BY table_schema;
Author Rich CollierPosted on December 16, 2016Format AsideCategories Linux, MySQL, Web DevelopmentLeave a comment on Get disk usage information for MySQL databases

Batch optimize images in bash

find . -type f -exec convert {} -resize 700×700> {} ;

Author Rich CollierPosted on May 21, 2013Format AsideCategories Linux, WordPressLeave a comment on Batch optimize images in bash

Find all files recursively and give them a different extension

find . -name “*.mp3” -exec rename .mp3 .mp3srbad {} ;

Author Rich CollierPosted on April 18, 2013Format AsideCategories LinuxLeave a comment on Find all files recursively and give them a different extension

Watch mysql processlist in (almost) real time

watch -n 1 “mysql -h 10.0.0.1 -u username -pPASSWORD -e ‘SHOW PROCESSLIST;'”

Author Rich CollierPosted on April 3, 2013Format AsideCategories LinuxLeave a comment on Watch mysql processlist in (almost) real time

Keep tabs on memory usage (in real time)

watch -n 1 “free -ml”

Author Rich CollierPosted on April 3, 2013Format AsideCategories LinuxLeave a comment on Keep tabs on memory usage (in real time)

Deadly process watch

ps -eo pcpu,pid,user,args | sort -k 1 -r | head -10

Author Rich CollierPosted on April 3, 2013Format AsideCategories LinuxLeave a comment on Deadly process watch

Chmod only directories recursively

find /path/you/want -type d -exec chmod 533 {} ;

Author Rich CollierPosted on April 2, 2013Format AsideCategories LinuxLeave a comment on Chmod only directories recursively

Chmod only files recursively

find /path/you/want -type f -exec chmod 644 {} ;

Author Rich CollierPosted on April 2, 2013Format AsideCategories LinuxLeave a comment on Chmod only files recursively
  • Travel
    • 11,000 Miles
    • Camping Trip 2022
    • Six States Trip
    • My Travel Maps
  • Tech
  • Family
  • About me
Theme: Twenty Sixteen. Rich Collier Powered by WordPress.com.