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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]