遇到问题时需要支持时需要提供以下清单
版本号(包含OBD和OB):ob 311bp1,obd 112
集群规模 单zone,3个observer
磁盘类型:
是否分盘部署:是
资源规格memory_limit 56G,system_memory 20G
是否设了时钟同步 是
问题的现象描述
MySQL [test]> show create table test;
| Table | Create Table |
±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test | CREATE TABLE
test
(
id
int(11) NOT NULL,
c2
varchar(50) DEFAULT NULL,
PRIMARY KEY (
id
)
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by range(id)
(partition p0 values less than (5),
partition p1 values less than (10)) |
±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
MySQL [test]> select * from test;
±—±-----+
| id | c2 |
±—±-----+
| 1 | 1 |
| 2 | 2 |
| 6 | 6 |
±—±-----+
3 rows in set (0.00 sec)
MySQL [test]> explain EXTENDED select * from test1;
| =====================================
|ID|OPERATOR |NAME |EST. ROWS|COST |
-------------------------------------
|0 |TABLE SCAN|test1|100000 |59654|
=====================================
Outputs & filters:
-------------------------------------
0 - output([test1.a(0x7f648df1d590)]), filter(nil),
access([test1.a(0x7f648df1d590)]), partitions(p0),
is_index_back=false,
range_key([test1.a(0x7f648df1d590)]), range(MIN ; MAX)always true
Used Hint:
-------------------------------------
/*+
*/
Outline Data:
-------------------------------------
/*+
BEGIN_OUTLINE_DATA
FULL(@“SEL$1” “test.test1”@“SEL$1”)
END_OUTLINE_DATA
*/
Plan Type:
-------------------------------------
LOCAL
Optimization Info:
-------------------------------------
test1:table_rows:100000, physical_range_rows:100000, logical_range_rows:100000, index_back_rows:0, output_rows:100000, est_method:basic_stat, optimization_method=cost_based, avaiable_index_name[test1]
Parameters
-------------------------------------
|