mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
69 lines
2.6 KiB
Text
69 lines
2.6 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;
|