percona-discussion team mailing list archive

[Vadim Tkachenko <vadim@xxxxxxxxxxx>]

Please specify version you are testing.
If this is for 5.1 - please report the same bug for official MySQL 5.1, as
this is standard feature.


On Thu, May 21, 2009 at 9:56 AM, Aleksandr Kuzminsky <
aleksandr.kuzminsky@xxxxxxxxxxx> wrote:

> 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;
>

-- 
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;