Doris DBA

数据库

# show databases;
create database tidat;

用户

create user bi identified by 'password';
-- set password for bi = password('abcd1234');
grant all on bidb to bi;

连接数

-- set property for 'bi' 'max_user_connections' = '200';
show property for 'bi' like '%max_user_connections%';

导出文件

# fe.conf
enable_outfile_to_local=true

# set enable_parallel_outfile = false;
# 对于普通路径，false=多个节点随机，true=多个节点多份全量
SELECT   identity_code,
         cast(identity_info as string) identity_info
FROM bi.ti_f_identity 
where part = 3
limit 30000000
INTO OUTFILE "file:///tmp/result000_"

SYS INFO

FE, BE

show proc '/frontends'
show proc '/backends'

SHOW PROPERTY FOR 'bi' LIKE '%max_user_connections%';
-- SET PROPERTY FOR 'bi' 'max_user_connections' = '200';
SHOW PROPERTY FOR 'bi' LIKE '%max_query_instances%';
SHOW PROPERTY FOR 'bi' LIKE '%qe_max_connection%';

查看当前连接数

show full processlist;
show processlist;