----+------------------------------+
| Variable_name | Value |
+---------------+------------------------------+
| datadir | /usr/local/mysql/data/mysql/ |
+---------------+------------------------------+
1 row in set (0.00 sec)
查看日志信息：
[root@mysrv ~]# cd /usr/local/mysql/data/mysql/
[root@mysrv mysql]# ls -l
total 29928
-rw-rw---- 1 mysql mysql 56 Jun 30 17:12 auto.cnf
-rw-rw---- 1 mysql mysql 18874368 Jul 8 15:17 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Jul 8 15:17 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 30 17:12 ib_logfile1
-rw-rw---- 1 mysql mysql 124 Jul 8 15:17 master.info
drwx--S--- 2 mysql mysql 4096 Jun 30 17:15 mysql
-rw-rw---- 1 mysql mysql 114 Jun 30 17:15 mysql-bin.000001
-rw-rw---- 1 mysql mysql 63438 Jun 30 17:15 mysql-bin.000002
-rw-rw---- 1 mysql mysql 1096670 Jun 30 17:15 mysql-bin.000003
-rw-rw---- 1 mysql mysql 252 Jun 30 17:26 mysql-bin.000004
-rw-rw---- 1 mysql mysql 114 Jun 30 17:40 mysql-bin.000005
-rw-rw---- 1 mysql mysql 133 Jun 30 17:51 mysql-bin.000006
-rw-rw---- 1 mysql mysql 114 Jun 30 17:56 mysql-bin.000007
-rw-rw---- 1 mysql mysql 114 Jul 8 15:17 mysql-bin.000008
-rw-rw---- 1 mysql mysql 157 Jul 8 15:18 mysql-bin.000009
-rw-rw---- 1 mysql mysql 157 Jul 8 15:20 mysql-bin.000010
-rw-rw---- 1 mysql mysql 114 Jul 8 15:20 mysql-bin.000011
-rw-rw---- 1 mysql mysql 209 Jul 8 15:20 mysql-bin.index
-rw-rw---- 1 mysql mysql 24920 Jul 8 15:21 mysrv.err
-rw-rw---- 1 mysql mysql 5 Jul 8 15:17 mysrv.pid
-rw-rw---- 1 mysql mysql 163 Jul 8 15:18 mysrv-relay-bin.000003
-rw-rw---- 1 mysql mysql 163 Jul 8 15:20 mysrv-relay-bin.000004
-rw-rw---- 1 mysql mysql 114 Jul 8 15:20 mysrv-relay-bin.000005
-rw-rw---- 1 mysql mysql 75 Jul 8 15:20 mysrv-relay-bin.index
drwx--S--- 2 mysql mysql 4096 Jun 30 17:15 performance_schema
drwx--S--- 2 mysql mysql 4096 Jun 30 18:15 prod
-rw-rw---- 1 mysql mysql 58 Jul 8 15:20 relay-log.info
drwx--S--- 2 mysql mysql 4096 Jun 30 17:15 test
mysrv-relay-bin.index，为记录日志文件的index文件
[root@mysrv mysql]# cat mysql-bin.index
./mysql-bin.000001
./mysql-bin.000002
./mysql-bin.000003
./mysql-bin.000004
./mysql-bin.000005
./mysql-bin.000006
./mysql-bin.000007
./mysql-bin.000008
./mysql-bin.000009
./mysql-bin.000010
./mysql-bin.000011
./mysql-bin.000012
./mysql-bin.000013
./mysql-bin.000014
2、二进制日志文件的切换
执行flush logs产生新的二进制日志：
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000011 | 114 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> flush logs;
Query OK, 0 rows affected (0.08 sec)
[root@mysrv mysql]# ls -l
total 29936
-rw-rw---- 1 mysql mysql 56 Jun 30 17:12 auto.cnf
-rw-rw---- 1 mysql mysql 18874368 Jul 8 15:17 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Jul 8 15:17 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 30 17:12 ib_logfile1
-rw-rw---- 1 mysql mysql 124 Jul 8 15:17 master.info
drwx--S--- 2 mysql mysql 4096 Jun 30 17:15 mysql
-rw-rw---- 1 mysql mysql 114 Jun 30 17:15 mysql-bin.000001
-rw-rw---- 1 mysql mysql 63438 Jun 30 17:15 mysql-bin.000002
-rw-rw---- 1 mysql mysql 1096670 Jun 30 17:15 mysql-bin.000003
-rw-rw---- 1 mysql mysql 252 Jun 30 17:26 mysql-bin.000004
-rw-rw-