[mythtv-users] Disabling MySQL binary logging ( log-bin ) (was Re: Disk space problem)

[Mark Garland]

Hi Mike,

Thanks also to both yourself and Michelle for your help in clearing up my
confusion here!

MG
-----
"The most overlooked advantage of owning a computer is that if they foul up
there's no law against whacking them around a bit."
 

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Michael T. Dean
Sent: 04 August 2009 19:25
To: Discussion about mythtv
Subject: Re: [mythtv-users] Disabling MySQL binary logging ( log-bin ) (was
Re: Disk space problem)

On 08/04/2009 02:16 PM, Michael T. Dean wrote:
> If your MySQL configuration file (and, specifically, the one that's 
> used when mysqld is started--which means if there's a $HOME/.my.cnf in 
> the environment of the user starting mysqld, you're not using 
> /etc/{,mysql/}my.cnf) has no mention of log-bin, binary logging is 
> disabled.
>
> On any sane distro, you shouldn't see mysqld started from an 
> environment with a HOME that causes a $HOME/.my.cnf to become visible, 
> so you're probably OK.  Just watch to see if you're getting some 
> fast-growing log files, or you can use SHOW BINARY LOGS; or SHOW 
> MASTER STATUS; in the mysql command line client (as a mysql user with 
> sufficient privileges--SUPER and/or REPLICATION CLIENT) to know for sure.

Or, actually, as an unprivileged user, you can use:

mysql> SHOW VARIABLES LIKE 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.02 sec)


Thanks, Michelle Agnew, for the suggestion.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users