[root@SR3 ~]# cd /mysqldata/
[root@SR3 mysqldata]# ls
binlog201311.txt ibdata1 ib_logfile1 mysql-bin.000001 mysql-bin.000003 mysql-bin.index SR3.err test
binlog2013.txt ib_logfile0 mysql mysql-bin.000002 mysql-bin.000004 performance_schema SR3.pid
[root@SR3 mysqldata]# service mysql restart
Shutting down MySQL..[ OK ]
Starting MySQL..ls
[ OK ]
[root@SR3 mysqldata]# ls
binlog201311.txt ibdata1 ib_logfile1 mysql-bin.000001 mysql-bin.000003 mysql-bin.000005 performance_schema SR3.pid
binlog2013.txt ib_logfile0 mysql mysql-bin.000002 mysql-bin.000004 mysql-bin.index SR3.err test
总结:启动后会产生mysql-bin这样的文件,每启动一次,就会增加一个或者多个。
[root@SR3 mysqldata]# service mysql restart
Shutting down MySQL.[ OK ]
Starting MySQL..[ OK ]
[root@SR3 mysqldata]# du -sh *
4.0K binlog201311.txt
4.0K binlog2013.txt
19M ibdata1
5.1M ib_logfile0
5.1M ib_logfile1
1000K mysql
28K mysql-bin.000001
980K mysql-bin.000002
4.0K mysql-bin.000003
4.0K mysql-bin.000004
4.0K mysql-bin.000005
4.0K mysql-bin.000006
4.0K mysql-bin.index
212K performance_schema
8.0K SR3.err
4.0K SR3.pid
16K test
[root@SR3 mysqldata]#
总结:
mysql-bin.00000n这样文件存放的是数据库每天增加的数据,所有数据库的数据增量都在这里面。