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
|
select plugin_status from information_schema.plugins where plugin_name='feedback';
plugin_status
ACTIVE
SELECT variable_value INTO @feedback_used FROM information_schema.feedback where variable_name = 'FEEDBACK used';
SELECT variable_value = @feedback_used + 1 as 'MUST BE 1' FROM information_schema.feedback where variable_name = 'FEEDBACK used';
MUST BE 1
1
select * from information_schema.feedback where variable_name like 'feed%'
and variable_name not like '%_uid' and variable_name not like 'FEEDBACK used'
and variable_name not like '%debug%';
VARIABLE_NAME VARIABLE_VALUE
FEEDBACK version 1.1
FEEDBACK_HTTP_PROXY
FEEDBACK_SEND_RETRY_WAIT 60
FEEDBACK_SEND_TIMEOUT 60
FEEDBACK_URL http://feedback.mariadb.org/rest/v1/post
FEEDBACK_USER_INFO mysql-test
SELECT VARIABLE_VALUE>0, VARIABLE_NAME FROM INFORMATION_SCHEMA.FEEDBACK
WHERE VARIABLE_NAME LIKE 'Collation used %'
ORDER BY VARIABLE_NAME;
VARIABLE_VALUE>0 VARIABLE_NAME
1 Collation used binary
1 Collation used latin1_swedish_ci
1 Collation used ucs2_general_ci
1 Collation used ucs2_uca1400_ai_ci
1 Collation used utf16_general_ci
1 Collation used utf16_uca1400_ai_ci
1 Collation used utf32_general_ci
1 Collation used utf32_uca1400_ai_ci
1 Collation used utf8mb3_bin
1 Collation used utf8mb3_general_ci
1 Collation used utf8mb3_uca1400_ai_ci
1 Collation used utf8mb4_bin
1 Collation used utf8mb4_general_ci
1 Collation used utf8mb4_uca1400_ai_ci
prepare stmt from "SELECT VARIABLE_VALUE>0, VARIABLE_NAME FROM INFORMATION_SCHEMA.FEEDBACK WHERE VARIABLE_NAME LIKE 'Collation used %' ORDER BY VARIABLE_NAME";
execute stmt;
VARIABLE_VALUE>0 VARIABLE_NAME
1 Collation used binary
1 Collation used latin1_swedish_ci
1 Collation used ucs2_general_ci
1 Collation used ucs2_uca1400_ai_ci
1 Collation used utf16_general_ci
1 Collation used utf16_uca1400_ai_ci
1 Collation used utf32_general_ci
1 Collation used utf32_uca1400_ai_ci
1 Collation used utf8mb3_bin
1 Collation used utf8mb3_general_ci
1 Collation used utf8mb3_uca1400_ai_ci
1 Collation used utf8mb4_bin
1 Collation used utf8mb4_general_ci
1 Collation used utf8mb4_uca1400_ai_ci
execute stmt;
VARIABLE_VALUE>0 VARIABLE_NAME
1 Collation used binary
1 Collation used latin1_swedish_ci
1 Collation used ucs2_general_ci
1 Collation used ucs2_uca1400_ai_ci
1 Collation used utf16_general_ci
1 Collation used utf16_uca1400_ai_ci
1 Collation used utf32_general_ci
1 Collation used utf32_uca1400_ai_ci
1 Collation used utf8mb3_bin
1 Collation used utf8mb3_general_ci
1 Collation used utf8mb3_uca1400_ai_ci
1 Collation used utf8mb4_bin
1 Collation used utf8mb4_general_ci
1 Collation used utf8mb4_uca1400_ai_ci
deallocate prepare stmt;
|
