1
source include/have_innodb.inc;
4
CREATE FUNCTION test_f()
5
RETURNS CHAR(30) DETERMINISTIC
7
DECLARE first VARCHAR(5);
8
DECLARE second VARCHAR(5);
9
DECLARE result VARCHAR(20);
10
SELECT SLEEP(1.11) INTO first;
13
SET result= CONCAT(first,second);
14
SET result= CONCAT(result,'world!');
19
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1;
20
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
21
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 2;
22
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
24
source include/percona_query_response_time_flush.inc;
25
source include/percona_query_response_time_show.inc;
27
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
32
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
34
source include/percona_query_response_time_show.inc;
36
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
37
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10;
38
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
40
source include/percona_query_response_time_flush.inc;
41
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
43
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
45
source include/percona_query_response_time_show.inc;
47
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
48
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 7;
49
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
51
source include/percona_query_response_time_flush.inc;
52
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
54
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
56
source include/percona_query_response_time_show.inc;
58
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
59
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 156;
60
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
62
source include/percona_query_response_time_flush.inc;
63
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
65
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
67
source include/percona_query_response_time_show.inc;
69
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
70
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1000;
71
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
73
source include/percona_query_response_time_flush.inc;
74
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
76
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
78
source include/percona_query_response_time_show.inc;
80
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
81
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1001;
82
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
84
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
85
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE =10;
b'\\ No newline at end of file'