| 1 |
--source include/have_innodb.inc |
| 2 |
--source include/have_partition.inc |
| 3 |
call mtr.add_suppression("innodb_buffer_pool_size change aborted"); |
| 4 |
CREATE TABLE t (c INT) ENGINE=InnoDB PARTITION BY HASH(c) PARTITIONS 512; |
| 5 |
BEGIN; |
| 6 |
SELECT * FROM t LOCK IN SHARE MODE; |
| 7 |
SET @save_size = @@GLOBAL.innodb_buffer_pool_size; |
| 8 |
--error 0,ER_WRONG_USAGE |
| 9 |
SET GLOBAL innodb_buffer_pool_size=6291456; |
| 10 |
COMMIT; |
| 11 |
--error 0,ER_WRONG_USAGE |
| 12 |
SET GLOBAL innodb_buffer_pool_size=6291456; |
| 13 |
SET GLOBAL innodb_buffer_pool_size = @save_size; |
| 14 |
DROP TABLE t; |