Apache Doris 中文技术论坛
Questions Tags Users Badges

doris的2.0.4,mysql的catalog的随机查询太慢,在mysql很快

Asked Jul 23, 2024 Modified Jan 1, 0001
Viewed 71
2.0

select
*
from
mysql_catalog.mysqldb.mysqltable
where
id >= ((
select
max(id)
from
mysql_catalog.mysqldb.mysqltable)-(
select
min(id)
from
mysql_catalog.mysqldb.mysqltable))* rand() + (
select
min(id)
from
mysql_catalog.mysqldb.mysqltable)
limit 0,5000

edited Jan 1, 0001
liaole7
asked Jul 23, 2024
1 Answers
  1. 可以基于query profile分析看看
  2. 可以升级至2.0最新的稳定版本2.0.13对比看看,排除些版本缺陷问题
edited Jan 1, 1970
张彬华7698
answered Jul 23, 2024
Related Questions
Doris 2.0.15,3FE、6BE(3BE mix角色 3BE computation角色)3个mix角色的BE节点CPU使用率100%
1 answers
Doris Routine Load自动恢复机制
我的doris版本为2.0.6 在备份操作时,会导致所以fe节点宕机,这种情况该怎么排查,为什么备份会导致这个问题?
1 answers
doris fe节点变更成高可用配置
1 answers
各位大哥在通过k8s安装doris3.0的时候,有没有遇到cg启动不起来,提示Set max number of open file descriptors to a value greater than 60000.
1 answers
doris主键表可以bucket配置太小,怎么修改?
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.