|
mysql> showmaster logs; #显示主服务器使用的二进制文件及大小
|
|
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001| 13814 |
| mysql-bin.000002| 150 |
| mysql-bin.000003| 150 |
| mysql-bin.000004| 150 |
| mysql-bin.000005| 150 |
| mysql-bin.000006| 126 |
| mysql-bin.000007| 126 |
| mysql-bin.000008| 126 |
| mysql-bin.000009| 107 |
| mysql-bin.000010| 353 |
+------------------+-----------+
10 rows in set (0.02sec)
mysql> showmaster status; #当前使用的二进制文件及所处位置
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB |Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000010| 353 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00sec)
|
小扩展：二进制日志的记录位置：通常为上一个事件执行结束时间的位置，每一个日志文件本身也有自己的元数据所以说对于当前版本的mysql来说二进制的开始位置通常为107；
|
Query OK, 0 rowsaffected (0.23 sec)
|
注意：flush logs一般只会滚动中继日志和二进制日志。
|
mysql> showmaster status;
|
|
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB |Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000011| 107 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00sec)
|
查看当前二进制文件的信息：
|
mysql> createdatabase yong;
|
|
Query OK, 1 rowaffected (0.12 sec)
|
|
mysql> createtable yong.tb1 (id int,name char(20));
|
|
Query OK, 0 rowsaffected (0.44 sec)
|
|
mysql> insertinto yong.tb1 values(1,'tom');
|
|
Query OK, 1 rowaffected (0.14 sec)
|
|
mysql> showmaster status;
|
|
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB |Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000011| 479 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00sec)
|
查看二进制日志信息的命令：
|
SHOW BINLOG EVENTS[IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
|
|
mysql> showbinlog eventsG #查看所有的二进制信息
|
