mysql-test/suite/innodb/r/innodb_buffer_pool_shrink.result
raw| 1 | call mtr.add_suppression("innodb_buffer_pool_size change aborted"); |
| 2 | CREATE TABLE t (c INT) ENGINE=InnoDB PARTITION BY HASH(c) PARTITIONS 512; |
| 3 | BEGIN; |
| 4 | SELECT * FROM t LOCK IN SHARE MODE; |
| 5 | c |
| 6 | SET @save_size = @@GLOBAL.innodb_buffer_pool_size; |
| 7 | SET GLOBAL innodb_buffer_pool_size=6291456; |
| 8 | COMMIT; |
| 9 | SET GLOBAL innodb_buffer_pool_size=6291456; |
| 10 | SET GLOBAL innodb_buffer_pool_size = @save_size; |
| 11 | DROP TABLE t; |