| 1 |
set completion_type=CHAIN; |
| 2 |
set global low_priority_updates=1; |
| 3 |
install soname 'sql_errlog'; |
| 4 |
select * from information_schema.system_variables |
| 5 |
where variable_name in ( |
| 6 |
'completion_type', #session!=global, origin=compile-time |
| 7 |
'low_priority_updates', #global!=default, origin=sql |
| 8 |
'column_compression_threshold', #origin=command-line |
| 9 |
'plugin_maturity', #origin=config |
| 10 |
'sql_error_log_rate', #plugin, origin=command-line |
| 11 |
'sql_error_log_rotations' #plugin, origin=config |
| 12 |
) |
| 13 |
order by variable_name; |
| 14 |
VARIABLE_NAME COLUMN_COMPRESSION_THRESHOLD |
| 15 |
SESSION_VALUE 120 |
| 16 |
GLOBAL_VALUE 120 |
| 17 |
GLOBAL_VALUE_ORIGIN COMMAND-LINE |
| 18 |
DEFAULT_VALUE 100 |
| 19 |
VARIABLE_SCOPE SESSION |
| 20 |
VARIABLE_TYPE INT UNSIGNED |
| 21 |
VARIABLE_COMMENT Minimum column data length eligible for compression |
| 22 |
NUMERIC_MIN_VALUE 0 |
| 23 |
NUMERIC_MAX_VALUE 4294967295 |
| 24 |
NUMERIC_BLOCK_SIZE 1 |
| 25 |
ENUM_VALUE_LIST NULL |
| 26 |
READ_ONLY NO |
| 27 |
COMMAND_LINE_ARGUMENT REQUIRED |
| 28 |
GLOBAL_VALUE_PATH NULL |
| 29 |
VARIABLE_NAME COMPLETION_TYPE |
| 30 |
SESSION_VALUE CHAIN |
| 31 |
GLOBAL_VALUE NO_CHAIN |
| 32 |
GLOBAL_VALUE_ORIGIN COMPILE-TIME |
| 33 |
DEFAULT_VALUE NO_CHAIN |
| 34 |
VARIABLE_SCOPE SESSION |
| 35 |
VARIABLE_TYPE ENUM |
| 36 |
VARIABLE_COMMENT The transaction completion type |
| 37 |
NUMERIC_MIN_VALUE NULL |
| 38 |
NUMERIC_MAX_VALUE NULL |
| 39 |
NUMERIC_BLOCK_SIZE NULL |
| 40 |
ENUM_VALUE_LIST NO_CHAIN,CHAIN,RELEASE |
| 41 |
READ_ONLY NO |
| 42 |
COMMAND_LINE_ARGUMENT REQUIRED |
| 43 |
GLOBAL_VALUE_PATH NULL |
| 44 |
VARIABLE_NAME LOW_PRIORITY_UPDATES |
| 45 |
SESSION_VALUE OFF |
| 46 |
GLOBAL_VALUE ON |
| 47 |
GLOBAL_VALUE_ORIGIN SQL |
| 48 |
DEFAULT_VALUE OFF |
| 49 |
VARIABLE_SCOPE SESSION |
| 50 |
VARIABLE_TYPE BOOLEAN |
| 51 |
VARIABLE_COMMENT INSERTvar/UPDATE has lower priority than selects |
| 52 |
NUMERIC_MIN_VALUE NULL |
| 53 |
NUMERIC_MAX_VALUE NULL |
| 54 |
NUMERIC_BLOCK_SIZE NULL |
| 55 |
ENUM_VALUE_LIST OFF,ON |
| 56 |
READ_ONLY NO |
| 57 |
COMMAND_LINE_ARGUMENT OPTIONAL |
| 58 |
GLOBAL_VALUE_PATH NULL |
| 59 |
VARIABLE_NAME PLUGIN_MATURITY |
| 60 |
SESSION_VALUE NULL |
| 61 |
GLOBAL_VALUE alpha |
| 62 |
GLOBAL_VALUE_ORIGIN CONFIG |
| 63 |
DEFAULT_VALUE gamma |
| 64 |
VARIABLE_SCOPE GLOBAL |
| 65 |
VARIABLE_TYPE ENUM |
| 66 |
VARIABLE_COMMENT The lowest desirable plugin maturity. Plugins less mature than that will not be installed or loaded |
| 67 |
NUMERIC_MIN_VALUE NULL |
| 68 |
NUMERIC_MAX_VALUE NULL |
| 69 |
NUMERIC_BLOCK_SIZE NULL |
| 70 |
ENUM_VALUE_LIST unknown,experimental,alpha,beta,gamma,stable |
| 71 |
READ_ONLY YES |
| 72 |
COMMAND_LINE_ARGUMENT REQUIRED |
| 73 |
GLOBAL_VALUE_PATH var/my.cnf |
| 74 |
VARIABLE_NAME SQL_ERROR_LOG_RATE |
| 75 |
SESSION_VALUE NULL |
| 76 |
GLOBAL_VALUE 100 |
| 77 |
GLOBAL_VALUE_ORIGIN COMMAND-LINE |
| 78 |
DEFAULT_VALUE 1 |
| 79 |
VARIABLE_SCOPE GLOBAL |
| 80 |
VARIABLE_TYPE INT UNSIGNED |
| 81 |
VARIABLE_COMMENT Sampling rate. If set to 0(zero), the logging is disabled |
| 82 |
NUMERIC_MIN_VALUE 0 |
| 83 |
NUMERIC_MAX_VALUE 1000000 |
| 84 |
NUMERIC_BLOCK_SIZE 1 |
| 85 |
ENUM_VALUE_LIST NULL |
| 86 |
READ_ONLY NO |
| 87 |
COMMAND_LINE_ARGUMENT REQUIRED |
| 88 |
GLOBAL_VALUE_PATH NULL |
| 89 |
VARIABLE_NAME SQL_ERROR_LOG_ROTATIONS |
| 90 |
SESSION_VALUE NULL |
| 91 |
GLOBAL_VALUE 5 |
| 92 |
GLOBAL_VALUE_ORIGIN CONFIG |
| 93 |
DEFAULT_VALUE 9 |
| 94 |
VARIABLE_SCOPE GLOBAL |
| 95 |
VARIABLE_TYPE INT UNSIGNED |
| 96 |
VARIABLE_COMMENT Number of rotations before log is removed |
| 97 |
NUMERIC_MIN_VALUE 1 |
| 98 |
NUMERIC_MAX_VALUE 999 |
| 99 |
NUMERIC_BLOCK_SIZE 1 |
| 100 |
ENUM_VALUE_LIST NULL |
| 101 |
READ_ONLY YES |
| 102 |
COMMAND_LINE_ARGUMENT REQUIRED |
| 103 |
GLOBAL_VALUE_PATH var/my.cnf |
| 104 |
create user foo@localhost; |
| 105 |
connect foo,localhost,foo; |
| 106 |
select global_value_path from information_schema.system_variables where variable_name='plugin_maturity'; |
| 107 |
global_value_path NULL |
| 108 |
connection default; |
| 109 |
select global_value_path from information_schema.system_variables where variable_name='plugin_maturity'; |
| 110 |
global_value_path var/my.cnf |
| 111 |
disconnect foo; |
| 112 |
drop user foo@localhost; |
| 113 |
set global low_priority_updates=default; |
| 114 |
uninstall soname 'sql_errlog'; |