Thursday, July 13, 2006

check mysql logging config for knoppmyth

Yesterday I encountered some unusual problems in MythTV. None of my recorded programs were showing at all. I ssh'd over, found out that the / partition (not the /myth) was full, *grumble grumble*, and started picking off low-hanging fruit with apt-get remove until things started working again. I run KnoppMyth, which by default has a lot installed, for ease of use.

Today I ran a series of 'du --max-depth=1 -h ' commands, starting in /var and working my way down. In retrospect a 'find' of some variety probably would be a better choice. In any case, /var/log/mysql/mysql.log was the obvious culprit: it was dutifully recording every operation. After some quality time with Google I found out that a line in /etc/mysql/my.cnf had to be commented out: 'log = /var/log/mysql/mysql.log'. Self-evident, once you know about it. I can't even guess why that option was enabled, but thank sweet zombie jesus mythtv is the only client of this mysql instance and I am the only user. I thought I used KnoppMyth to avoid dealing with these kinds of issues? I guess I shouldn't complain, it's not as if I'm trying to run Myth on gentoo...

1 comment:

  1. Anonymous8:17 AM

    That's funny... I just ran into the same problem on my Knopmyth install too. Thanks for the help.