Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Tree: 52c63a6cbe
Fetching contributors…

Cannot retrieve contributors at this time

93 lines (92 sloc) 4.293 kB
SET @start_global_value = @@global.innodb_reserve_free_extents;
SELECT @start_global_value;
@start_global_value
1
Valid values are 'ON' and 'OFF'
SELECT @@GLOBAL.innodb_reserve_free_extents IN (0, 1);
@@GLOBAL.innodb_reserve_free_extents IN (0, 1)
1
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
1
SELECT @@SESSION.innodb_reserve_free_extents;
ERROR HY000: Variable 'innodb_reserve_free_extents' is a GLOBAL variable
SHOW GLOBAL VARIABLES LIKE 'innodb_reserve_free_extents';
Variable_name Value
innodb_reserve_free_extents ON
SHOW SESSION VARIABLES LIKE 'innodb_reserve_free_extents';
Variable_name Value
innodb_reserve_free_extents ON
SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SET GLOBAL innodb_reserve_free_extents='OFF';
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
0
SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS OFF
SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS OFF
SET @@GLOBAL.innodb_reserve_free_extents=1;
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
1
SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SET GLOBAL innodb_reserve_free_extents=0;
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
0
SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS OFF
SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS OFF
SET @@GLOBAL.innodb_reserve_free_extents='ON';
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
1
SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SET SESSION innodb_reserve_free_extents='OFF';
ERROR HY000: Variable 'innodb_reserve_free_extents' is a GLOBAL variable and should be set with SET GLOBAL
SET @@SESSION.innodb_reserve_free_extents='ON';
ERROR HY000: Variable 'innodb_reserve_free_extents' is a GLOBAL variable and should be set with SET GLOBAL
SET GLOBAL innodb_reserve_free_extents=1.1;
ERROR 42000: Incorrect argument type to variable 'innodb_reserve_free_extents'
SET GLOBAL innodb_reserve_free_extents=1e1;
ERROR 42000: Incorrect argument type to variable 'innodb_reserve_free_extents'
SET GLOBAL innodb_reserve_free_extents=2;
ERROR 42000: Variable 'innodb_reserve_free_extents' can't be set to the value of '2'
NOTE: The following should fail with ER_WRONG_VALUE_FOR_VAR (BUG#50643)
SET GLOBAL innodb_reserve_free_extents=-3;
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
1
SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_reserve_free_extents';
VARIABLE_NAME VARIABLE_VALUE
INNODB_RESERVE_FREE_EXTENTS ON
SET GLOBAL innodb_reserve_free_extents='AUTO';
ERROR 42000: Variable 'innodb_reserve_free_extents' can't be set to the value of 'AUTO'
SET @@GLOBAL.innodb_reserve_free_extents = @start_global_value;
SELECT @@GLOBAL.innodb_reserve_free_extents;
@@GLOBAL.innodb_reserve_free_extents
1
Jump to Line
Something went wrong with that request. Please try again.