Re: bin files in var/log/mysql

[Michael Schurter <michael@synthesyssolutions.com>]

Brent Clark wrote:
> I saw all a few bin files in var/log/mysql.
>
> trinity:/var/log/mysql# ls -la
> total 5760
> drwxr-s---  2 mysql adm    4096 2006-05-18 07:47 .
> drwxr-xr-x 13 root  root   4096 2006-05-18 08:13 ..
> -rw-rw----  1 mysql adm  145221 2006-05-13 07:35 mysql-bin.000133
> -rw-rw----  1 mysql adm  178978 2006-05-14 07:35 mysql-bin.000134
> -rw-rw----  1 mysql adm   99868 2006-05-15 07:58 mysql-bin.000135
> -rw-rw----  1 mysql adm   97529 2006-05-16 07:52 mysql-bin.000136
> -rw-rw----  1 mysql adm   73481 2006-05-17 07:52 mysql-bin.000137
> -rw-rw----  1 mysql adm  422265 2006-05-18 07:47 mysql-bin.000138
> -rw-rw----  1 mysql adm  248005 2006-05-18 14:07 mysql-bin.000139
> -rw-rw----  1 mysql adm     800 2006-05-18 07:47 mysql-bin.index
>
> Could anyone please tell me what are these for, and I would like to know 
> how come they dont get compress / rotated. It seem like files will just 
> keep on getting created with out old files been deleted.

These files are for replication and recovery.  I believe there are 
settings in your my.cnf to configure their max size.  I'm not sure why 
they aren't rotated automatically.

For MySQL 4.x:
http://dev.mysql.com/doc/refman/4.1/en/binary-log.html

For MySQL 5.x:
http://dev.mysql.com/doc/refman/5.1/en/binary-log.html

Michael Schurter