Demaestro
msg:4083499 | 3:21 pm on Feb 19, 2010 (gmt 0) |
Well I can't speak to the consequences of not having the bin logging but you can delete them without losing data.
If you issue these commands at certain intervals you can get rid of them, or as you mentioned you can turn of bin logging.
mysql> flush logs;
mysql> reset master;
You can view the contents of the bin files by using mysqlbinlog and piping the output to a txt file
sudo mysqlbinlog /var/lib/mysql/mysqld-bin.000001 > log.txt
|
mack
msg:4083537 | 4:34 pm on Feb 19, 2010 (gmt 0) |
are .bin files not in some way related to replication? I have had issues in the past with very large bin files and removed them with no issue.
Mack.
|
Demaestro
msg:4083567 | 6:07 pm on Feb 19, 2010 (gmt 0) |
I am going by memory here but I think that the bin files also have a log of transactions but I may be wrong on that.
|
|
