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)快,查了几倍,有什么优化方案嘛
