Doris使用SSD创建表报错,查询效率比oracle稍慢怎么优化

Viewed 7

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Failed to find enough backend, please check the replication num,replication tag and storage medium and avail capacity of backends or maybe all be on same host. Backends details: backends with tag {"location" : "default"} is [[backendId=1764923299556, host=10.0.0.12, hdd disks count={ok=1,}, ssd disk count={}], [backendId=1765415974632, host=10.0.0.79, hdd disks count={ok=1,}, ssd disk count={}]],
Create failed replications:
replication tag: {"location" : "default"}, replication num: 1, storage medium: SSD

创建表报错如上,找不到SSD,但是虚拟机上已经是购买了SSD了
"storage_medium" = "SSD" 这个参数设置会影响查询速度嘛,
目前同样数据量下5000W ,进行主键点查,doris(60ms)没有oracle(15ms)快,查了几倍,有什么优化方案嘛
a8c78b7576c53b7049d1429d23fe4d10.png

1 Answers
  1. 建表语句是什么,是指定了storage medium 为 SSD吗?Doris不会自动识别存储介质,需要在be.conf 中的 storage_root_path 打tag。一般如果全部是SSD,不需要指定 storage medium。
  2. 查询可以实际看看profile

您可以加我主页微信,我们一起看看