How to delete lots of rows from a MySQL database without indefinite locking

Interesting post over at the Flare blog, where they had to delete over 900 million records from a MySQL table. They couldn’t simply run a DELETE FROM table query, as that would lock it: When a deletion query using a WHERE clause starts, it will lock that table. All other queries that are run against …

Disable all Keyboard and Trackpad Input with Little Fingers

If you have a toddler running around, Little Fingers by Shaun Inman – who created it for his own need – will come in handy. Little fingers want to explore. Press Shift + Control + Option + Command + L to lock down your Keyboard, Trackpad, Touch Bar, and/or Mouse. Press it again to unlock. …