It appears that hard drives don’t like it… It also proves that some sysadmins have far too much time to spare. 😉
Tag: sysadmin
Who’s linking to your site?
If you’re using LogMiner to analyse your Apache/IIS logs, here’s an easy recipe to be notified of sites that send visitors your way. First, let’s define a Pg/PLSQL function to extract the new referrers: 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748CREATE TYPE new_referrer AS ( site_id int8, site_name text, …
lm_sensors config for Asus T3-P5945GCX (P5L13L motherboard)
I’ve just installed the latest Mandriva 2008.1 RC on this fine Asus barebone. Everything went fine, except that the output of sensors showed too many ALARM messages for my taste… so, here’s how I’ve modified the pre-installed sensors.conf to set some min/max values closer to reality and to hide useless lines: 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748# Winbond W83627EHF configuration …
LogMiner: purging old accesses
I’ve just committed a function to easily purge old data from LogMiner’s database, useful to prevent it from growing too much. It’ll appear in the next version, but since its release might still be far from now, here’s the code for those who need it: 123456789101112131415161718192021222324252627282930313233343536373839CREATE OR REPLACE FUNCTION cleanup( _site int8, _upToDate DATE ) …
Mac OS X version statistics through CFNetwork analysis
Recently I needed to gather some statistics about the distribution of the different Mac OS X versions installed by users of a certain application. Since the application has an update-check feature, I thought I’d use the web server logs to infer the data I was interested in. The only thing I could use was the …