31 lines
1.0 KiB
Plaintext
31 lines
1.0 KiB
Plaintext
--disable_query_log
|
|
set @@session.explicit_defaults_for_timestamp=off;
|
|
--enable_query_log
|
|
# owner: bin.lb
|
|
# owner group: SQL2
|
|
# tags: dml
|
|
# description:
|
|
#
|
|
#alter system set balance_worker_idle_sleep_seconds=33 COMMENT 'new all balance_worker_idle_sleep_seconds' SERVer_TYPE = ROOTSERVER cluster = 0;
|
|
|
|
#alter system set balance_worker_idle_sleep_seconds=39 COMMENT 'new1 root balance_worker_idle_sleep_seconds' SERVer_TYPE = ROOTSERVER server_ip = '127.0.0.1' server_port = 47051;
|
|
|
|
create table t_status(id int primary key, chunkserver char(90), mergesrver char(90), rootserver char(90), updateserver char(90), tablet_max_size int, status int);
|
|
|
|
insert into t_status(id, chunkserver, tablet_max_size, status) values(1, 'chunkserver', 1024, 0);
|
|
|
|
select id, chunkserver, status from t_status;
|
|
|
|
select id, chunkserver, status as verbose from t_status;
|
|
|
|
select id, chunkserver, grants.status as verbose from t_status grants;
|
|
|
|
--error 1064
|
|
select use_bloom_filter() from dual;
|
|
|
|
--error 1305
|
|
select use_bloom() from dual;
|
|
|
|
drop table t_status;
|
|
|