These are your binary transaction logs used for replication and
for restoring to current state from last nights backup tape.
Bill Rausch wrote:
> Hi,
>
> My machine (linux if it matters) is named "naif". In my
> /usr/local/mysql/var directory, in addition to what I expect to see,
> there are a number of files named naif-bin.001, naif-bin.002, ...,
> naif-bin.009. Some of these files are quite large, nearly 100
> megabytes. What are they? There is also a small file named
> naif-bin.index.
>
> Thanks,
>
> Bill
>
> $ sudo ls -l var
> total 191608
> ...
> drwx------ 2 mysql mysql 4096 Apr 19 11:13 mysql
> -rw-rw---- 1 mysql mysql 57755399 Jun 4 16:27 naif-bin.001
> -rw-rw---- 1 mysql mysql 93484844 Jun 5 15:32 naif-bin.002
> -rw-rw---- 1 mysql mysql 73 Jun 5 16:52 naif-bin.003
> -rw-rw---- 1 mysql mysql 73 Jun 5 17:05 naif-bin.004
> -rw-rw---- 1 mysql mysql 86 Jun 5 17:08 naif-bin.005
> -rw-rw---- 1 mysql mysql 827434 Jun 7 15:44 naif-bin.006
> -rw-rw---- 1 mysql mysql 4725 Jun 7 16:11 naif-bin.007
> -rw-rw---- 1 mysql mysql 43766150 Jun 17 13:00 naif-bin.008
> -rw-rw---- 1 mysql mysql 82322 Jun 25 09:02 naif-bin.009
> -rw-rw---- 1 mysql mysql 135 Jun 17 13:04 naif-bin.index
> -rw-r--r-- 1 mysql root 1474 Jun 17 13:04 naif.err
> -rw-rw---- 1 mysql mysql 3 Jun 17 13:04 naif.pid
> drwx------ 2 mysql mysql 4096 Apr 19 11:13 test
>
