percona-discussion team mailing list archive

[Aleksandr Kuzminsky <aleksandr.kuzminsky@xxxxxxxxxxx>]

Public bug reported:

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;

** Affects: percona-patches
     Importance: Undecided
         Status: New

-- 
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: New

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;