Optimizing a very simple MySQL query: use WHERE instead of LIMIT 02 April 2016, edited 08 July 2016 Posted in: Sysadmin About: A friend had problems with MySQL because it was not using an existing index for a query. A huge number of queries were rebuild into one which was 4000x faster than each of the previous ones.
Automatically update a Debian/Ubuntu using apt-get and cron 05 June 2014, edited 26 July 2016 Posted in: Sysadmin About: Using cron to run apt-get update and upgrade commands. Use with care.