1-- source include/have_innodb.inc 2# 3# first, ensure that we _can_ set various options without limitation 4# 5SET @TEMP=@@GLOBAL.AUTO_INCREMENT_INCREMENT; 6 7SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=1; 8SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT; 9 10SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=2; 11SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT; 12 13SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=15; 14SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT; 15 16SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=@TEMP; 17SET @TEMP=@@LOCAL.AUTO_INCREMENT_INCREMENT; 18 19SET @@LOCAL.AUTO_INCREMENT_INCREMENT=1; 20SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT; 21 22SET @@LOCAL.AUTO_INCREMENT_INCREMENT=2; 23SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT; 24 25SET @@LOCAL.AUTO_INCREMENT_INCREMENT=15; 26SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT; 27 28SET @@LOCAL.AUTO_INCREMENT_INCREMENT=@TEMP; 29 30SET @@GLOBAL.AUTO_INCREMENT_OFFSET=5; 31 32SET @@LOCAL.AUTO_INCREMENT_OFFSET=5; 33 34SELECT @@GLOBAL.BINLOG_ROW_IMAGE; 35 36SELECT @@LOCAL.BINLOG_ROW_IMAGE; 37 38SET @@GLOBAL.BINLOG_ROW_IMAGE= MINIMAL; 39 40SET @@LOCAL.BINLOG_ROW_IMAGE= MINIMAL; 41 42SET @TEMP=@@GLOBAL.INNODB_IO_CAPACITY; 43 44SET @@GLOBAL.INNODB_IO_CAPACITY=100; 45SELECT @@GLOBAL.INNODB_IO_CAPACITY; 46 47SET @@GLOBAL.INNODB_IO_CAPACITY=300; 48SELECT @@GLOBAL.INNODB_IO_CAPACITY; 49 50SET @@GLOBAL.INNODB_IO_CAPACITY=160; 51SELECT @@GLOBAL.INNODB_IO_CAPACITY; 52 53SET @@GLOBAL.INNODB_IO_CAPACITY=@TEMP; 54 55SET @@GLOBAL.INNODB_SPIN_WAIT_DELAY=10; 56 57SET @@GLOBAL.INNODB_READ_AHEAD_THRESHOLD=32; 58 59# 60# restart the server with some options modifiers and limits 61# 62--let $restart_parameters=restart:--auto-increment-increment=7 --minimum-auto-increment-increment=5 --maximum-auto-increment-increment=10 --readonly-auto-increment-offset=TRUE --hidden-binlog-row-image=TRUE --innodb-io-capacity=150 --minimum-innodb-io-capacity=150 --maximum-innodb-io-capacity=200 --readonly-innodb-spin-wait-delay=TRUE --hidden-innodb-read-ahead-threshold=TRUE 63--source include/restart_mysqld.inc 64 65# 66# test the limits set by the above options modifiers 67# 68SET @TEMP=@@GLOBAL.AUTO_INCREMENT_INCREMENT; 69 70SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=1; 71SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT; 72 73SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=2; 74SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT; 75 76SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=15; 77SELECT @@GLOBAL.AUTO_INCREMENT_INCREMENT; 78 79SET @@GLOBAL.AUTO_INCREMENT_INCREMENT=@TEMP; 80SET @TEMP=@@LOCAL.AUTO_INCREMENT_INCREMENT; 81 82SET @@LOCAL.AUTO_INCREMENT_INCREMENT=1; 83SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT; 84 85SET @@LOCAL.AUTO_INCREMENT_INCREMENT=2; 86SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT; 87 88SET @@LOCAL.AUTO_INCREMENT_INCREMENT=15; 89SELECT @@LOCAL.AUTO_INCREMENT_INCREMENT; 90 91SET @@LOCAL.AUTO_INCREMENT_INCREMENT=@TEMP; 92 93--error ER_INCORRECT_GLOBAL_LOCAL_VAR 94SET @@GLOBAL.AUTO_INCREMENT_OFFSET=5; 95 96--error ER_INCORRECT_GLOBAL_LOCAL_VAR 97SET @@LOCAL.AUTO_INCREMENT_OFFSET=5; 98 99--error ER_UNKNOWN_SYSTEM_VARIABLE 100SELECT @@GLOBAL.BINLOG_ROW_IMAGE; 101 102--error ER_UNKNOWN_SYSTEM_VARIABLE 103SELECT @@LOCAL.BINLOG_ROW_IMAGE; 104 105--error ER_UNKNOWN_SYSTEM_VARIABLE 106SET @@GLOBAL.BINLOG_ROW_IMAGE= MINIMAL; 107 108--error ER_UNKNOWN_SYSTEM_VARIABLE 109SET @@LOCAL.BINLOG_ROW_IMAGE= MINIMAL; 110 111 112SET @TEMP=@@GLOBAL.INNODB_IO_CAPACITY; 113 114SET @@GLOBAL.INNODB_IO_CAPACITY=100; 115SELECT @@GLOBAL.INNODB_IO_CAPACITY; 116 117SET @@GLOBAL.INNODB_IO_CAPACITY=300; 118SELECT @@GLOBAL.INNODB_IO_CAPACITY; 119 120SET @@GLOBAL.INNODB_IO_CAPACITY=160; 121SELECT @@GLOBAL.INNODB_IO_CAPACITY; 122 123SET @@GLOBAL.INNODB_IO_CAPACITY=@TEMP; 124 125--error ER_INCORRECT_GLOBAL_LOCAL_VAR 126SET @@GLOBAL.INNODB_SPIN_WAIT_DELAY=10; 127 128--error ER_UNKNOWN_SYSTEM_VARIABLE 129SET @@GLOBAL.INNODB_READ_AHEAD_THRESHOLD=32; 130 131# 132# Now test allowed modifier combinations 133# 134--let $restart_parameters=restart:--readonly-loose-auto-increment-offset=TRUE --hidden-loose-binlog-row-image=TRUE --readonly-loose-innodb-spin-wait-delay=TRUE --hidden-loose-innodb-read-ahead-threshold=TRUE 135--source include/restart_mysqld.inc 136 137--error ER_INCORRECT_GLOBAL_LOCAL_VAR 138SET @@GLOBAL.AUTO_INCREMENT_OFFSET=5; 139 140--error ER_INCORRECT_GLOBAL_LOCAL_VAR 141SET @@LOCAL.AUTO_INCREMENT_OFFSET=5; 142 143--error ER_UNKNOWN_SYSTEM_VARIABLE 144SELECT @@GLOBAL.BINLOG_ROW_IMAGE; 145 146--error ER_UNKNOWN_SYSTEM_VARIABLE 147SELECT @@LOCAL.BINLOG_ROW_IMAGE; 148 149--error ER_UNKNOWN_SYSTEM_VARIABLE 150SET @@GLOBAL.BINLOG_ROW_IMAGE= MINIMAL; 151 152--error ER_UNKNOWN_SYSTEM_VARIABLE 153SET @@LOCAL.BINLOG_ROW_IMAGE= MINIMAL; 154 155--error ER_INCORRECT_GLOBAL_LOCAL_VAR 156SET @@GLOBAL.INNODB_SPIN_WAIT_DELAY=10; 157 158--error ER_UNKNOWN_SYSTEM_VARIABLE 159SET @@GLOBAL.INNODB_READ_AHEAD_THRESHOLD=72; 160