1
-- source include/have_binlog_format_mixed_or_statement.inc
2
-- echo # Activate master-slave replication
3
-- source include/master-slave.inc
6
-- echo # Make table t for test
8
DROP TABLE IF EXISTS t;
10
CREATE TABLE t(id INT);
13
-- echo # Start slave replication
17
-- source include/wait_for_slave_to_start.inc
20
#-- echo # Make insert(1) on master
22
INSERT INTO t VALUES (1);
23
sync_slave_with_master;
25
-- echo # Read and change log_slow_slave_statements to ON on slave
26
show variables like 'log_slow_slave_statements';
27
set global log_slow_slave_statements=ON;
28
show variables like 'log_slow_slave_statements';
30
#-- echo # Make insert(2) on master
32
INSERT INTO t VALUES (2);
33
sync_slave_with_master;
35
-- echo # Restart slave
37
-- source include/wait_for_slave_to_stop.inc
39
-- source include/wait_for_slave_to_start.inc
41
#-- echo # Make insert(3) on master
43
INSERT INTO t VALUES (3);
44
sync_slave_with_master;
46
show variables like 'long_query_time';
47
show global variables like 'long_query_time';
48
show global variables like 'use_global_long_query_time';
49
set global long_query_time=0;
50
show variables like 'long_query_time';
51
show global variables like 'long_query_time';
52
show global variables like 'use_global_long_query_time';
54
#-- echo # Make insert(4) on master
56
INSERT INTO t VALUES (4);
57
sync_slave_with_master;
59
show variables like 'long_query_time';
60
show global variables like 'long_query_time';
61
show global variables like 'use_global_long_query_time';
62
set global use_global_long_query_time=1;
63
show variables like 'long_query_time';
64
show global variables like 'long_query_time';
65
show global variables like 'use_global_long_query_time';
67
#-- echo # Make insert(5) on master
69
INSERT INTO t VALUES (5);
70
sync_slave_with_master;
72
show variables like 'long_query_time';
73
show global variables like 'long_query_time';
74
show global variables like 'use_global_long_query_time';
75
set global long_query_time=1;
76
set global use_global_long_query_time=0;
78
-- echo # Analyse master slow_query_log
81
let $cmd=cat ./var/mysqld.1/data/percona_log_slow_slave_statements-master.log | grep;
84
let $current_cmd = $cmd "INSERT INTO t VALUES ($k)" | wc -l;
90
-- echo # Analyse slave slow_query_log
93
let $cmd=cat ./var/mysqld.2/data/percona_log_slow_slave_statements-slave.log | grep;
96
let $current_cmd = $cmd "INSERT INTO t VALUES ($k)" | wc -l;
101
set global log_slow_slave_statements=OFF;
106
sync_slave_with_master;