List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 29 2002 8:39pm
Subject:Re: What's data/*-bin.*?
View as plain text  
At 16:03 -0400 8/29/02, Philip Mak wrote:
>What are all these rei-bin.* files in this MySQL data directory? Are
>they needed? They're taking up a lot of disk space. They seem to be
>some sort of log.
>
>horde                    rei.aaanime.net.pid  rei-bin.008  rei-bin.016
>linkwars                 rei-bin.001          rei-bin.009  rei-bin.017
>my.cnf                   rei-bin.002          rei-bin.010  rei-bin.018
>mysql                    rei-bin.003          rei-bin.011  rei-bin.019
>plesk.rackshack.net.err  rei-bin.004          rei-bin.012  rei-bin.020
>plesk.rackshack.net.pid  rei-bin.005          rei-bin.013  rei-bin.021
>psa                      rei-bin.006          rei-bin.014  rei-bin.022
>rei.aaanime.net.err      rei-bin.007          rei-bin.015  rei-bin.index


The binary update logs.  They serve as a record of updated, to be used
for two primary purposes:
- To be sent to slave replication servers
- To be used for data recovery purposes after a crash

The rei-bin.index file is an index of the binary log files.  It records
which binary logs the server is maintaining.
Thread
What's data/*-bin.*?Philip Mak30 Aug
  • Re: What's data/*-bin.*?Paul DuBois30 Aug