percona-discussion team mailing list archive

[Yasufumi Kinoshita <yasufumi.kinoshita@xxxxxxxxxxx>]

http://bazaar.launchpad.net/~percona-dev/percona-
patches/5.1.34/revision/6

This may be bug of MySQL-5.1.34...

** Branch linked: lp:~percona-dev/percona-patches/5.1.34

** Changed in: percona-patches
       Status: New => Fix Committed

-- 
log_slow_slave_statements doesn't work
https://bugs.launchpad.net/bugs/379115
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: Fix Committed

Bug description:
Queries issued on a master are not logged on a slave's slow log.

>From mysq-test test(microslow_innodb_log_slow_slave_statements):
..
connection master;
CREATE TABLE t1(
  id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  name VARCHAR(255)
  );
INSERT INTO t1(name) VALUES('aaa');

connection slave;
SELECT * FROM t1;
...

The test was run as:
./mtr --record --mysqld=--log_slow_slave_statements=1 microslow_innodb_log_slow_slave_statements

The slave's slow log(CREATE and INSERT are missing in it):
SET long_query_time=0;
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 2  Schema: test
# Query_time: 0.000401  Lock_time: 0.000289  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Rows_read: 1
SET timestamp=1242924506;
SELECT * FROM t1;