67 lines
2.9 KiB
Plaintext
67 lines
2.9 KiB
Plaintext
***********************************************************************
|
|
* Run only on debug build,non-windows as few server variables are not
|
|
* available on all platforms.
|
|
***********************************************************************
|
|
call mtr.add_suppression("Failed to set up SSL because of the following SSL library error");
|
|
***************************************************************
|
|
* 0. Verify that variables present in performance_schema.global
|
|
* variables are actually global variables and can be set using
|
|
* SET GLOBAL
|
|
***************************************************************
|
|
CREATE TABLE global_vars (id INT PRIMARY KEY AUTO_INCREMENT, var_name VARCHAR(64), var_value VARCHAR(1024));
|
|
INSERT INTO global_vars (var_name, var_value) SELECT * FROM
|
|
performance_schema.global_variables
|
|
WHERE variable_name like 'xengine_%'
|
|
AND variable_name NOT IN
|
|
('xengine_hotbackup',
|
|
'xengine_rate_limiter_bytes_per_sec', ## cannot be reset
|
|
'xengine_shrink_table_space');
|
|
************************************************************
|
|
* 1. Check that there are no persisted variable settings.
|
|
************************************************************
|
|
include/assert.inc ['Expect 0 persisted variables.']
|
|
|
|
************************************************************
|
|
* 2. Initialization. Test SET PERSIST. Verify persisted
|
|
* variables.
|
|
************************************************************
|
|
CREATE TABLE all_vars (id INT PRIMARY KEY AUTO_INCREMENT, var_name VARCHAR(64), var_value VARCHAR(1024));
|
|
INSERT INTO all_vars (var_name, var_value)
|
|
SELECT * FROM performance_schema.global_variables
|
|
WHERE variable_name LIKE 'xengine_%'
|
|
AND variable_name NOT IN
|
|
('xengine_hotbackup',
|
|
'xengine_rate_limiter_bytes_per_sec', ## cannot be reset
|
|
'xengine_shrink_table_space')
|
|
ORDER BY variable_name;
|
|
|
|
include/assert.inc [Expect 79 variables in the table. Due to some restriction, we are checking for 76]
|
|
|
|
# Test SET PERSIST
|
|
|
|
include/assert.inc [Expect 45 persisted variables in the table.]
|
|
|
|
************************************************************
|
|
* 3. Restart server, it must preserve the persisted variable
|
|
* settings. Verify persisted configuration.
|
|
************************************************************
|
|
# restart
|
|
|
|
include/assert.inc [Expect 45 persisted variables in persisted_variables table.]
|
|
include/assert.inc [Expect 45 persisted variables shown as PERSISTED in variables_info table.]
|
|
include/assert.inc [Expect 45 persisted variables with matching persisted and global values.]
|
|
|
|
************************************************************
|
|
* 4. Test RESET PERSIST IF EXISTS. Verify persisted variable
|
|
* settings are removed.
|
|
************************************************************
|
|
|
|
include/assert.inc ['Expect 0 persisted variables.']
|
|
|
|
************************************************************
|
|
* 5. Clean up.
|
|
************************************************************
|
|
DROP TABLE all_vars;
|
|
DROP TABLE global_vars;
|
|
# restart
|