来自mysql控制台的mysql binlog路径

Question

有没有办法从 mysql 控制台知道 bin 日志文件路径，因为我们可以通过使用知道它是打开还是关闭

Select * information_schema.GLOBAL_VARIABLES
where variable_name like '%log_bin%'. 

Answer 1

用它来显示开/关:

SHOW VARIABLES LIKE 'log_bin'

还有:

SHOW GLOBAL VARIABLES LIKE '%bin%'

或者

SHOW SESSION VARIABLES LIKE ...

更多信息:(请注意其中一些值和结果从 5.5 更改为 5.6!)

http://dev.mysql.com/doc/refman/5.5/en/show-master-status.html

mysql > SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73       | test         | manual,mysql     |
+---------------+----------+--------------+------------------+

mysql> SHOW BINARY LOGS;
+---------------+-----------+
| Log_name      | File_size |
+---------------+-----------+
| binlog.000015 |    724935 |
| binlog.000016 |    733481 |
+---------------+-----------+