← Back to branch summary

~akopytov/percona-server/bug1126077

« back to all changes in this revision

Viewing changes to Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result

  • Committer: jenkins at percona
  • Date: 2013-02-11 03:45:48 UTC
  • mfrom: (396.4.1 slow-log-fixes-5.5)
  • Revision ID: jenkins@jenkins.percona.com-20130211034548-pujhuyj20y50p0w5
Merge lp:~laurynas-biveinis/percona-server/slow-log-fixes-5.5

Show diffs side-by-side

added added

removed removed

Lines of Context:
Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result
 
1
include/master-slave.inc
 
2
[connection master]
 
3
SET SESSION min_examined_row_limit=0;
 
4
DROP TABLE IF EXISTS t;
 
5
CREATE TABLE t(id INT,data CHAR(30)) ENGINE=InnoDB;
 
6
INSERT INTO t VALUES
 
7
(1,"aaaaabbbbbcccccdddddeeeeefffff"),
 
8
(2,"aaaaabbbbbcccccdddddeeeeefffff"),
 
9
(3,"aaaaabbbbbcccccdddddeeeeefffff"),
 
10
(4,"aaaaabbbbbcccccdddddeeeeefffff"),
 
11
(5,"aaaaabbbbbcccccdddddeeeeefffff");
 
12
INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
 
13
INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
 
14
SET GLOBAL long_query_time=0;
 
15
SET GLOBAL log_slow_slave_statements=TRUE;
 
16
SET GLOBAL log_slow_verbosity='innodb';
 
17
include/restart_slave.inc
 
18
[log_start.inc] percona.slow_extended.log_slow_slave_statements-innodb
 
19
INSERT INTO t SELECT t.id,t.data from t;
 
20
[log_stop.inc] percona.slow_extended.log_slow_slave_statements-innodb
 
21
[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements-innodb pattern: InnoDB_IO_r_ops
 
22
[log_grep.inc] lines:   1
 
23
DROP TABLE t;
 
24
SET GLOBAL long_query_time=default;
 
25
SET GLOBAL log_slow_slave_statements=default;
 
26
SET GLOBAL log_slow_verbosity=default;
 
27
SET SESSION min_examined_row_limit=default;
 
28
include/rpl_end.inc