1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
# TEST 3
# Select status and system variable tables using ORDER BY to exercise the
# rnd_pos() method
#
use performance_schema;
select * from global_variables order by variable_name;
select * from variables_by_thread order by variable_name;
select * from session_variables order by variable_name;
select * from global_status order by variable_name;
select * from session_status order by variable_name;
select * from status_by_thread order by variable_name;
select * from status_by_user order by variable_name;
select * from status_by_host order by variable_name;
select * from status_by_account order by variable_name;
# TEST 4
# Handling of SHOW STATUS/VARIABLES ... WHERE
#
SHOW STATUS WHERE VARIABLE_NAME LIKE "foo";
Variable_name Value
SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
Variable_name Value
SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
Variable_name Value
SHOW VARIABLES WHERE VARIABLE_NAME LIKE "foo";
Variable_name Value
SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
Variable_name Value
SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
Variable_name Value
# TEST 5
# Confirm FLUSH STATUS resets counters for all threads.
#
# Create a new connection
# Record thread id
# Increase bytes_received for new connection
USE test;
SHOW TABLES;
Tables_in_test
USE performance_schema;
# Record bytes_received for other connection
SELECT variable_value FROM status_by_thread
WHERE variable_name = "bytes_received" and thread_id = @thread_id INTO @bytes_before;
# Reset status counters
FLUSH STATUS;
# Record bytes_received after reset
SELECT variable_value FROM status_by_thread
WHERE variable_name = "bytes_received" and thread_id = @thread_id INTO @bytes_after;
# Expect bytes_before > bytes_after
SELECT @bytes_before > @bytes_after AS 'Expect 1';
Expect 1
1
# Expect bytes_after is zero
SELECT @bytes_after AS 'Expect 0';
Expect 0
0
# TEST 6
#
# Bug#28291258 FLUSH STATUS ADDS TWICE TO GLOBAL VALUES
#
# Default connection
# First connection
include/assert.inc [Global value requested from the first session must not change]
# Generate a slow query
SET long_query_time = 2;
SELECT SLEEP(4);
SLEEP(4)
0
SET long_query_time = @@global.long_query_time;
include/assert.inc [Global value requested from the first session after SLEEP() must increase by 1]
include/assert.inc [First session value must increase by 1]
# Default connection
include/assert.inc [Global value requested from the default session after DISCONNECT must remain the same]
include/assert.inc [Default session value must remain zero]
FLUSH STATUS;
include/assert.inc [Global value requested from the default session after FLUSH must remain the same]
include/assert.inc [Default session value after FLUSH must remain zero]
|
