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

Michael T. Dean mtdean at thirdcontact.com
Tue Aug 4 18:25:26 UTC 2009


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


More information about the mythtv-users mailing list