3
DROP TABLE IF EXISTS t;
4
CREATE TABLE t(id INT);
10
INSERT INTO t VALUES (1);
11
sync_slave_with_master;
14
show variables like 'log_slow_slave_statements';
15
set global log_slow_slave_statements=ON;
16
show variables like 'log_slow_slave_statements';
19
INSERT INTO t VALUES (2);
20
sync_slave_with_master;
27
INSERT INTO t VALUES (3);
28
sync_slave_with_master;
31
show variables like 'long_query_time';
32
show global variables like 'long_query_time';
33
show global variables like 'slow_query_log_use_global_control';
34
set global long_query_time=0;
35
show variables like 'long_query_time';
36
show global variables like 'long_query_time';
37
show global variables like 'slow_query_log_use_global_control';
40
INSERT INTO t VALUES (4);
41
sync_slave_with_master;
44
show variables like 'long_query_time';
45
show global variables like 'long_query_time';
46
show global variables like 'slow_query_log_use_global_control';
47
set global slow_query_log_use_global_control='long_query_time';
48
show variables like 'long_query_time';
49
show global variables like 'long_query_time';
50
show global variables like 'slow_query_log_use_global_control';
52
#-- echo # Make insert(5) on master
54
INSERT INTO t VALUES (5);
55
sync_slave_with_master;
57
show variables like 'long_query_time';
58
show global variables like 'long_query_time';
59
show global variables like 'slow_query_log_use_global_control';
60
set global long_query_time=1;
61
set global slow_query_log_use_global_control='';
70
--let grep_file = $MYSQLTEST_VARDIR/mysqld.1/data/percona_log_slow_slave_statements-master.log
71
--let grep_pattern = INSERT INTO t VALUES \($k\)
72
--source include/grep.inc
84
--let grep_file = $MYSQLTEST_VARDIR/mysqld.2/data/percona_log_slow_slave_statements-slave.log
85
--let grep_pattern = INSERT INTO t VALUES \($k\)
86
--source include/grep.inc
90
set global log_slow_slave_statements=OFF;
94
sync_slave_with_master;