mysql-test/suite/sys_vars/t/innodb_buffer_pool_evict_basic.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

-- source include/have_innodb.inc
# This is a debug variable for now
-- source include/have_debug.inc

SET @save_innodb_read_only_compressed=@@GLOBAL.innodb_read_only_compressed;
SELECT @@global.innodb_buffer_pool_evict;

SET GLOBAL innodb_read_only_compressed=ON;
--error ER_UNSUPPORTED_COMPRESSED_TABLE
CREATE TABLE t(a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
SET GLOBAL innodb_read_only_compressed=OFF;

CREATE TABLE t(a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
SET GLOBAL innodb_buffer_pool_evict = 'uncompressed';

# Should always be empty.
SELECT @@global.innodb_buffer_pool_evict;
DROP TABLE t;
SET GLOBAL innodb_read_only_compressed=@save_innodb_read_only_compressed;