Data Science Manager at Hospital IQ – Planet discoverer, researcher, developer, geek.

(TIL) MySql: Show full query in process list

less than 1 minute read

SHOW PROCESSLIST

only shows the first 100 characters of the running SQL query. To get the full SQL query, use:

SHOW FULL PROCESSLIST

Via SO.

(TIL) Mac: Ask user for password via GUI

less than 1 minute read

This function will use AppleScript to present a password entry dialog to make your scripts a little more user friendly:

10 minute read

List Available Timezones:

less than 1 minute read

You can restart or shutdown from the command line:

less than 1 minute read

Restore sane shell settings, in case your shell session went insane because some script or application turned it into a garbled mess: