[mythtv-users] Any ideas how to make my hard drive shut up?

[Andrew Cope]

Phill Edwards wrote:
>> It turns out that my MySQL data base is getting HAMMERED!
>>
>> The  /var/log/mysql/mysql.log is growing very fast.  I was going to
>> post 5 seconds worth of data here, but it was several hundred lines
>> long.
>>
>> Doing ps -aux does not show any occurences of mythfilldatabase
>>
>> Any ideas what may be causing this?  Where is this verbose logging set?
> 
> Perhaps there's verbose logging options being used on your mythbackend
> or mythfrontend startup commands. Or in /etc/sysconfig/mythbackend,
> maybe?


You can turn off the log file in /etc/mysql/my.cnf by commenting out
this line:

log = /var/log/mysql/mysql.log  # might be different on your system

Mysql will continue to write a more efficient binary log.

Cheers
A
--
Email:    andrew at evergreencomputing.com
Website:  http://evergreencomputing.com
Phone:    +44 (0)1454 269 087
Fax:      +44 (0)8707 515 596