percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00660
[Bug 379115] Re: log_slow_slave_statements doesn't work
For 5.1.34, log_slow_slave_statements is native option of MySQL.
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slow-slave-statements
I think the patches of 5.1.34 does not touch the option....
I will investigate it. So, where the test-script is?
--
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;
Follow ups
References