mirror of
https://github.com/MariaDB/server.git
synced 2025-08-01 03:47:19 +03:00
359c286499
preallocate max. count of THDs puge might need at startup. Doing this at any other point of time is difficult, error prone
64 lines
1.7 KiB
Plaintext
64 lines
1.7 KiB
Plaintext
# Variable name: innodb_purge_threads
|
|
# Scope: Global
|
|
# Access type: Static
|
|
# Data type: numeric
|
|
|
|
--source include/have_innodb.inc
|
|
|
|
SELECT COUNT(@@GLOBAL.innodb_purge_threads);
|
|
--echo 1 Expected
|
|
|
|
SELECT COUNT(@@innodb_purge_threads);
|
|
--echo 1 Expected
|
|
|
|
SET @save_threads = @@GLOBAL.innodb_purge_threads;
|
|
|
|
SET @@GLOBAL.innodb_purge_threads=-1;
|
|
SELECT @@GLOBAL.innodb_purge_threads;
|
|
SET @@GLOBAL.innodb_purge_threads=0;
|
|
SELECT @@GLOBAL.innodb_purge_threads;
|
|
SET @@GLOBAL.innodb_purge_threads=33;
|
|
SELECT @@GLOBAL.innodb_purge_threads;
|
|
|
|
SET @@GLOBAL.innodb_purge_threads=1;
|
|
SET @@GLOBAL.innodb_purge_threads=32;
|
|
|
|
--Error ER_BAD_FIELD_ERROR
|
|
SELECT innodb_purge_threads = @@SESSION.innodb_purge_threads;
|
|
--echo Expected error 'Read-only variable'
|
|
|
|
--disable_warnings
|
|
SELECT @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE
|
|
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
|
|
WHERE VARIABLE_NAME='innodb_purge_threads';
|
|
--enable_warnings
|
|
--echo 1 Expected
|
|
|
|
--disable_warnings
|
|
SELECT COUNT(VARIABLE_VALUE)
|
|
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
|
|
WHERE VARIABLE_NAME='innodb_purge_threads';
|
|
--enable_warnings
|
|
--echo 1 Expected
|
|
|
|
SELECT @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads;
|
|
--echo 1 Expected
|
|
|
|
--Error ER_INCORRECT_GLOBAL_LOCAL_VAR
|
|
SELECT COUNT(@@local.innodb_purge_threads);
|
|
--echo Expected error 'Variable is a GLOBAL variable'
|
|
|
|
--Error ER_INCORRECT_GLOBAL_LOCAL_VAR
|
|
SELECT COUNT(@@SESSION.innodb_purge_threads);
|
|
--echo Expected error 'Variable is a GLOBAL variable'
|
|
|
|
# Check the default value
|
|
--disable_warnings
|
|
SELECT VARIABLE_NAME, VARIABLE_VALUE
|
|
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
|
|
WHERE VARIABLE_NAME = 'innodb_purge_threads';
|
|
--enable_warnings
|
|
|
|
|
|
SET GLOBAL innodb_purge_threads = @save_threads;
|