| 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;
+------------------+----------+--------------+------------------+
+------------------+----------+--------------+------------------+
| 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-