mirror of
https://github.com/MariaDB/server.git
synced 2025-02-14 09:25:35 +01:00
73 lines
2.8 KiB
Text
73 lines
2.8 KiB
Text
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;
|
|
set global sql_mode=ONLY_FULL_GROUP_BY;
|
|
# restart
|
|
feedback plugin: report to 'http://feedback.mariadb.org/rest/v1/post' was sent
|
|
feedback plugin: server replied 'ok'
|