| 1 |
# Variable: innodb_redo_log_archive_dirs |
| 2 |
# Default : NULL |
| 3 |
# Scope : GLOBAL |
| 4 |
# Dynamic : Yes |
| 5 |
|
| 6 |
## Save variable |
| 7 |
SET @innodb_redo_log_archive_dirs_sav= @@global.innodb_redo_log_archive_dirs; |
| 8 |
|
| 9 |
## Show default value |
| 10 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 11 |
|
| 12 |
## Valid cases |
| 13 |
## Syntax: semi-colon separated list of labeled path names. |
| 14 |
## Path names are not checked when the variable is set. |
| 15 |
# |
| 16 |
SET @@global.innodb_redo_log_archive_dirs="label1:/dir1"; |
| 17 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 18 |
# |
| 19 |
SET @@global.innodb_redo_log_archive_dirs="label1:/dir1;label2:dir2"; |
| 20 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 21 |
# |
| 22 |
## A single trailing semi-colon is allowed. |
| 23 |
# |
| 24 |
SET @@global.innodb_redo_log_archive_dirs="label1:/dir1;"; |
| 25 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 26 |
# |
| 27 |
SET @@global.innodb_redo_log_archive_dirs="label1:dir1;label2:/dir2;"; |
| 28 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 29 |
# |
| 30 |
## Label can be empty, but colon must exist. |
| 31 |
# |
| 32 |
SET @@global.innodb_redo_log_archive_dirs=":/dir1"; |
| 33 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 34 |
# |
| 35 |
## Labels are not checked for uniqueness. Nor are path names. |
| 36 |
# |
| 37 |
SET @@global.innodb_redo_log_archive_dirs=":dir1;:dir1"; |
| 38 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 39 |
# |
| 40 |
## Label can contain every character, but colon. Example label ";;;". |
| 41 |
# |
| 42 |
SET @@global.innodb_redo_log_archive_dirs=";;;:/dir1"; |
| 43 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 44 |
# |
| 45 |
## Path can contain every character, but semi-colon. Example path ":::". |
| 46 |
# |
| 47 |
SET @@global.innodb_redo_log_archive_dirs="label::::"; |
| 48 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 49 |
# |
| 50 |
## Example: Two times in a row label ";;;", path ":::", trailing semi-colon. |
| 51 |
# |
| 52 |
SET @@global.innodb_redo_log_archive_dirs=";;;::::;;;;::::;"; |
| 53 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 54 |
# |
| 55 |
## Variable can be empty. |
| 56 |
# |
| 57 |
SET @@global.innodb_redo_log_archive_dirs=""; |
| 58 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 59 |
# |
| 60 |
## Variable can be NULL. |
| 61 |
# |
| 62 |
SET @@global.innodb_redo_log_archive_dirs=NULL; |
| 63 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 64 |
# |
| 65 |
## Variable can be persisted. |
| 66 |
# |
| 67 |
SET PERSIST innodb_redo_log_archive_dirs="label1:/dir1"; |
| 68 |
SELECT @@global.innodb_redo_log_archive_dirs; |
| 69 |
RESET PERSIST innodb_redo_log_archive_dirs; |
| 70 |
|
| 71 |
## Invalid cases |
| 72 |
--error ER_GLOBAL_VARIABLE |
| 73 |
SET innodb_redo_log_archive_dirs="label1:/dir1"; |
| 74 |
--error ER_GLOBAL_VARIABLE |
| 75 |
SET @@local.innodb_redo_log_archive_dirs="label1:/dir1"; |
| 76 |
--error ER_GLOBAL_VARIABLE |
| 77 |
SET @@innodb_redo_log_archive_dirs="label1:/dir1"; |
| 78 |
--error ER_GLOBAL_VARIABLE |
| 79 |
SET @@session.innodb_redo_log_archive_dirs="label1:/dir1"; |
| 80 |
|
| 81 |
## Invalid cases |
| 82 |
# Label missing |
| 83 |
--error ER_WRONG_VALUE_FOR_VAR |
| 84 |
SET @@global.innodb_redo_log_archive_dirs="/dir1"; |
| 85 |
## Path missing. |
| 86 |
--error ER_WRONG_VALUE_FOR_VAR |
| 87 |
SET @@global.innodb_redo_log_archive_dirs=":"; |
| 88 |
--error ER_WRONG_VALUE_FOR_VAR |
| 89 |
SET @@global.innodb_redo_log_archive_dirs="l1:"; |
| 90 |
# (Second) Label missing |
| 91 |
--error ER_WRONG_VALUE_FOR_VAR |
| 92 |
SET @@global.innodb_redo_log_archive_dirs=":d1;;"; |
| 93 |
--error ER_WRONG_VALUE_FOR_VAR |
| 94 |
SET @@global.innodb_redo_log_archive_dirs=":d1;d2"; |
| 95 |
# (Second) Path missing |
| 96 |
--error ER_WRONG_VALUE_FOR_VAR |
| 97 |
SET @@global.innodb_redo_log_archive_dirs="l1:d1;l2:"; |
| 98 |
# (Second) Path missing |
| 99 |
--error ER_WRONG_VALUE_FOR_VAR |
| 100 |
SET @@global.innodb_redo_log_archive_dirs="l1:d1;l2:;"; |
| 101 |
|
| 102 |
# Repeated execution of SET @@global.innodb_redo_log_archive_dirs |
| 103 |
--disable_warnings |
| 104 |
DROP PROCEDURE IF EXISTS test.innodb_redo_log_archive_dirs; |
| 105 |
--enable_warnings |
| 106 |
DELIMITER |; |
| 107 |
CREATE PROCEDURE test.innodb_redo_log_archive_dirs (IN start BIGINT, IN nam CHAR(20)) |
| 108 |
BEGIN |
| 109 |
DECLARE CONTINUE HANDLER FOR 13178 SET @x2 = 1; |
| 110 |
SET @idx=start; |
| 111 |
SET @n=nam; |
| 112 |
WHILE (@idx > 0) DO |
| 113 |
SET @s=CONCAT("SET @@global.innodb_redo_log_archive_dirs='1:../www/",@n,@idx,"'"); |
| 114 |
Prepare stmt from @s; |
| 115 |
Execute stmt; |
| 116 |
SET @@global.innodb_redo_log_archive_dirs=""; |
| 117 |
SET @idx = @idx - 1; |
| 118 |
END WHILE; |
| 119 |
END| |
| 120 |
DELIMITER ;| |
| 121 |
CALL test.innodb_redo_log_archive_dirs(100,'s'); |
| 122 |
DROP PROCEDURE test.innodb_redo_log_archive_dirs; |
| 123 |
|
| 124 |
## Restore variable |
| 125 |
SET @@global.innodb_redo_log_archive_dirs= @innodb_redo_log_archive_dirs_sav; |