log_slow_slave_statements doesn't work with log_slow_verbosity=innodb

Bug #600684 reported by Oleg Tsarev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Oleg Tsarev

Bug Description

If we:

1) setup:
set long_query_time=0;
set log_slow_verbosity=innodb;
set global log_slow_slave_statements=ON;
on master and slave
2) restart slave thread (in other case log_slow_slave_statements doesn't affect)
3) run insert queries on master

actual:

# User@Host: [SQL_SLAVE] @ []
# Thread_id: 7 Schema: test Last_errno: 0 Killed: 0
# Query_time: 0.007577 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 930 Rows_affected: 900 Rows_read: 900
# Bytes_sent: 0 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 126992
# No InnoDB statistics available for this query
SET timestamp=1277997479;
INSERT INTO t SELECT t2.id from t as t1, t as t2;

Insert queries replicated to slave doesn't have InnoDB stats in slow query

expected:

All queries replicated to slave and go to slow query log should include InnoDB stats, if we setup it.

Test attached (this not clear test, this only way for extract log with trouble)

Revision history for this message
Oleg Tsarev (tsarev) wrote :
Revision history for this message
Oleg Tsarev (tsarev) wrote :
Revision history for this message
Oleg Tsarev (tsarev) wrote :
Changed in percona-server:
assignee: nobody → Oleg Tsarev (tsarev)
importance: Undecided → Medium
milestone: none → 5.1-12.0
status: New → Triaged
Oleg Tsarev (tsarev)
Changed in percona-server:
status: Triaged → In Progress
Oleg Tsarev (tsarev)
Changed in percona-server:
status: In Progress → Fix Committed
Changed in percona-server:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1145

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.