1
--source include/master-slave.inc
4
DROP TABLE IF EXISTS t;
5
CREATE TABLE t(id INT);
8
sync_slave_with_master;
12
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1;
13
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
14
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10;
15
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
16
source include/percona_query_response_time_flush.inc;
17
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=ON;
20
INSERT INTO t VALUES(0);
21
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
22
INSERT INTO t VALUES(1);
23
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
24
sync_slave_with_master;
27
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
28
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
30
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 2;
31
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
32
source include/percona_query_response_time_flush.inc;
35
INSERT INTO t VALUES(0);
36
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
37
INSERT INTO t VALUES(1);
38
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
39
sync_slave_with_master;
42
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
43
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
46
DROP TABLE IF EXISTS t;
47
sync_slave_with_master;
49
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10;
50
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=OFF;