Index

Getting munin to run every 10 minutes

Munin is kind of inefficient and on my P4 2Ghz, it running every 5 minutes is too often, and the munin processes keep dying because locks already exist. You can't increase the munin-cron script to 10 minute intervals, because then rrdtool will generate gaps. Read More »
By halfgaar, 9 years ago, on December 18, 2012, at 16:12 | 3 comments

My zeroth year at university

Maybe my biggest accomplishment to date—maybe my only real accomplishment, if your glasses are so colored by society's standards—has been to be accepted to the University of Groningen as a fulltime biology student. To apply, I had to send my curriculum and a letter of motivation. Which motivation? I wasn't so sure that I'd like to be a student. Actually, I had been quite certain for most of my adult life that I really did not want to study and waste all that precious time for a few crums of knowledge. Read More »
By Rowan Rodrik, 9 years ago, on December 16, 2012, at 17:12 | 4 comments

Adding a clock in screen to avoid your ssh’s from being killed

The world is filled with stupid routers, which kill all connections that have no activity for a while (even a very short while). I keep loosing my SSH sessions because of this. To fix it, I added a clock in my GNU screen bar: Read More »
By halfgaar, 10 years ago, on October 31, 2012, at 11:10 | 5 comments

Trying to reduce MySQL InnoDB disk usage after major reduction of data

So, two days ago, I tried to shrink my MediaWiki database and it almost worked, except the MySQL process wouldn't shrink along with it. Read More »
By Rowan Rodrik, 10 years ago, on October 24, 2012, at 18:10 | 2 comments

Shrinking/compressing a MediaWiki database

As of late, I haven't had a lot of time to chase after spammers, so – despite of anti-spam captchas and everything – a couple of my wikis have been overgrowing with spam. One after the other I've been closing them down to anonymous edits, even closing down user registration alltogether, but some a little too late. Read More »
By Rowan Rodrik, 10 years ago, on October 24, 2012, at 16:10 | 1 comment

Converting all tables in MySQL DB to InnoDB

#!/bin/bash exit 1 dbname="eorder" echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t | mysql $dbname Read More »
By halfgaar, 10 years ago, on October 02, 2012, at 14:10 | 5 comments

Translating Dutch programming error messages

In .NET, you get Dutch errors when your Windows is in Dutch, which is hugely annoying. You can use this site to translate them, so that you can Google them. Read More »
By halfgaar, 10 years ago, on August 09, 2012, at 15:08 | 1 comment

My universal remote programming codes

Whenever this remote's battery is loose for a while, it forgets its programming. So, here it is: For computer, use the TV setting. Press 1 and 3 for a few seconds, then when the light turns on, enter 0677 as code. Read More »
By halfgaar, 10 years ago, on August 06, 2012, at 21:08 | Comments closed

Kart racing scores

I want to keep track of my kart racing scores: dateTrackRacerfastest Time 2012-07-24Long BeachWiebe55.95 2012-07-24Long BeachWiebe56.22 2012-07-24Long BeachWiebe58.84 Read More »
By halfgaar, 10 years ago, on July 25, 2012, at 15:07 | Comments closed

Apache mod_proxy configuration for The Pirate Bay

I found several apache mod_proxy configs for setting up a proxy for The Pirate Bay, but none worked fully. Read More »
By halfgaar, 10 years ago, on July 13, 2012, at 16:07 | 7 comments