[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