set completion_type=CHAIN;
set global low_priority_updates=1;
install soname 'sql_errlog';
select * from information_schema.system_variables
where variable_name in (
'completion_type',                #session!=global, origin=compile-time
'low_priority_updates',           #global!=default, origin=sql
'column_compression_threshold',   #origin=command-line
'plugin_maturity',                #origin=config
'sql_error_log_rate',             #plugin, origin=command-line
'sql_error_log_rotations'         #plugin, origin=config
)
order by variable_name;
VARIABLE_NAME	COLUMN_COMPRESSION_THRESHOLD
SESSION_VALUE	120
GLOBAL_VALUE	120
GLOBAL_VALUE_ORIGIN	COMMAND-LINE
DEFAULT_VALUE	100
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Minimum column data length eligible for compression
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	COMPLETION_TYPE
SESSION_VALUE	CHAIN
GLOBAL_VALUE	NO_CHAIN
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	NO_CHAIN
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	The transaction completion type
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NO_CHAIN,CHAIN,RELEASE
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	LOW_PRIORITY_UPDATES
SESSION_VALUE	OFF
GLOBAL_VALUE	ON
GLOBAL_VALUE_ORIGIN	SQL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	INSERTvar/UPDATE has lower priority than selects
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	PLUGIN_MATURITY
SESSION_VALUE	NULL
GLOBAL_VALUE	alpha
GLOBAL_VALUE_ORIGIN	CONFIG
DEFAULT_VALUE	gamma
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	The lowest desirable plugin maturity. Plugins less mature than that will not be installed or loaded
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	unknown,experimental,alpha,beta,gamma,stable
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	var/my.cnf
VARIABLE_NAME	SQL_ERROR_LOG_RATE
SESSION_VALUE	NULL
GLOBAL_VALUE	100
GLOBAL_VALUE_ORIGIN	COMMAND-LINE
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Sampling rate. If set to 0(zero), the logging is disabled.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	1000000
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	SQL_ERROR_LOG_ROTATIONS
SESSION_VALUE	NULL
GLOBAL_VALUE	5
GLOBAL_VALUE_ORIGIN	CONFIG
DEFAULT_VALUE	9
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Number of rotations before log is removed.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	999
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	var/my.cnf
create user foo@localhost;
connect foo,localhost,foo;
select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
global_value_path	NULL
connection default;
select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
global_value_path	var/my.cnf
disconnect foo;
drop user foo@localhost;
set global low_priority_updates=default;
uninstall soname 'sql_errlog';