社区版3.1.3,关闭px后执行计划仍能看到GI算子。
用例:
CREATE TABLE sbtest1
(
id
int(11) NOT NULL AUTO_INCREMENT,
k
int(11) NOT NULL DEFAULT ‘0’,
c
char(120) NOT NULL DEFAULT ‘’,
pad
char(60) NOT NULL DEFAULT ‘’,
PRIMARY KEY (id
),
KEY k_1
(k
) BLOCK_SIZE 16384 LOCAL
) AUTO_INCREMENT = 11000001 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = ‘lz4_1.0’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by hash(id)
(partition p0,
partition p1,
partition p2,
partition p3,
partition p4,
partition p5)
尝试关闭隐参_ob_use_parallel_execution后也一样:
这是什么原因呢?