Testing the examples in the book by Charles Bell,Mats Kindahl and Lars Thalmann.I try to check the binlog by using the instruction "SHOW BINLOG EVENTS\G".But it returns "Empty set (0.00 sec)" .Where am I wrong? Here is the my.cnf:
[mysqld]
host = localhost
user = jun
password = 111
port = 3306
socket = /var/lib/mysql/mysqld.sock
pid-file = /var/lib/mysql/mysqld.pid
basedir = /var/lib/mysql
datadir = /usr
log-bin = /var/log/mysql/master-bin
log-bin-index = /var/log/mysql/master-bin.index
server-id = 1
tmpdir = /tmp
The terminal output below:
mysql> use test1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from tb1;
+-------+
| text |
+-------+
| YEAH! |
+-------+
1 row in set (0.00 sec)
mysql> flush logs;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW BINLOG EVENTS\G
Empty set (0.00 sec)
mysql> exit
Bye
juneau@linux-dfxe:~> cd /var/log/mysql/
juneau@linux-dfxe:/var/log/mysql> ll
total 0
juneau@linux-dfxe:/var/log/mysql>