oceanbase

1
system sleep 5;
2
alter system set balancer_idle_time = '10s';
3
create user if not exists 'admin' IDENTIFIED BY 'admin';
4
use oceanbase;
5
create database if not exists test;
6

7
use test;
8
grant all on *.* to 'admin' WITH GRANT OPTION;
9

10

11

12
alter system set enable_syslog_wf=false;
13
set @@session.ob_query_timeout = 200000000;
14

15
source init_create_tenant_routines.sql;
16

17
call adjust_sys_resource();
18
call create_tenant_with_arg('mysql', 'mysql', '2c2g', '');
19

20
/****************************** ATTENTION ******************************/
21
/* The tenant=all will be deprecated. If you want all tenants to be    */
22
/* modified, use tenant=sys & tenant=all_user & tenant=all_meta.       */
23
/***********************************************************************/
24
set @@session.ob_query_timeout = 10000000;
25
system sleep 5;
26
alter tenant sys set variables recyclebin = 'on';
27
alter tenant sys set variables ob_enable_truncate_flashback = 'on';
28
alter tenant mysql set variables ob_tcp_invited_nodes='%';
29
alter tenant mysql set variables recyclebin = 'on';
30
alter tenant mysql set variables ob_enable_truncate_flashback = 'on';
31
alter tenant sys set variables _nlj_batching_enabled = true;
32
alter tenant mysql set variables _nlj_batching_enabled = true;
33
alter system set ob_compaction_schedule_interval = '10s' tenant sys;
34
alter system set ob_compaction_schedule_interval = '10s' tenant all_user;
35
alter system set ob_compaction_schedule_interval = '10s' tenant all_meta;
36
alter system set merger_check_interval = '10s' tenant sys;
37
alter system set merger_check_interval = '10s' tenant all_user;
38
alter system set merger_check_interval = '10s' tenant all_meta;
39
alter system set enable_sql_extension=true tenant sys;
40
alter system set enable_sql_extension=true tenant all_user;
41
alter system set enable_sql_extension=true tenant all_meta;
42
alter system set _enable_adaptive_compaction = false tenant sys;
43
alter system set _enable_adaptive_compaction = false tenant all_user;
44
alter system set _enable_adaptive_compaction = false tenant all_meta;
45
alter system set_tp tp_no = 1200, error_code = 4001, frequency = 1;
46
alter system set_tp tp_no = 509, error_code = 4016, frequency = 1;
47
alter system set_tp tp_no = 368, error_code = 4016, frequency = 1;
48
alter system set_tp tp_no = 551, error_code = 5434, frequency = 1;
49

50
alter system set _enable_var_assign_use_das = true tenant = sys;
51
alter system set _enable_var_assign_use_das = true tenant = all_user;
52
alter system set _enable_var_assign_use_das = true tenant = all_meta;
53
alter system set _enable_spf_batch_rescan = true tenant = sys;
54
alter system set _enable_spf_batch_rescan = true tenant = all_user;
55
alter system set _enable_spf_batch_rescan = true tenant = all_meta;