percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00663
[Bug 379115] Re: log_slow_slave_statements doesn't work
If you want to log "CREATE TABLE" here, log-slow-admin-statements option
is also needed.
--
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;
References