全部产品
云市场

ALTER_SYSTEM

更新时间:2019-09-18 13:14:01

BOOTSTRAP

  1. alter_system_bootstrap_stmt:
  2. ALTER SYSTEM BOOTSTRAP region_zone_server_list;
  3. region_zone_server_list:
  4. region_zone_server [, region_zone_server ...]
  5. region_zone_server:
  6. [region] zone server
  7. region:
  8. REGION [=] region_name
  9. zone:
  10. ZONE [=] zone_name
  11. server:
  12. SERVER [=] ip_port
  13. ip_port:
  14. 'STR_VALUE:INT_VALUE'

JOB

  1. alter_system_job_stmt:
  2. ALTER SYSTEM RUN JOB job_name
  3. {zone | server};

MERGE

  1. alter_system_merge_stmt:
  2. ALTER SYSTEM merge_action;
  3. merge_action:
  4. MAJOR FREEZE
  5. [IGNORE ip_port_list]
  6. | MINOR FREEZE
  7. [tenant_list | replica] [server_list] [zone]
  8. | START MERGE
  9. zone
  10. | {SUSPEND | RESUME} MERGE
  11. [zone]
  12. | CLEAN MERGE ERROR
  13. tenant_list:
  14. TENANT [=] (tenant_name_list)
  15. tenant_name_list:
  16. tenant_name [, tenant_name ...]
  17. replica:
  18. PARTITION_ID [=] 'partition_idx%partition_count@table_id'
  19. server_list:
  20. SERVER [=] ip_port_list

PARAMETER

  1. alter_system_parameter_stmt:
  2. ALTER SYSTEM [SET]
  3. parameter_name = expression [SCOPE = {MEMORY | SPFILE | BOTH}] [comment];

REFRESH

  1. alter_system_refresh_stmt:
  2. ALTER SYSTEM refresh_action;
  3. refresh_action:
  4. REFRESH SCHEMA
  5. [zone | server]
  6. | REFRESH TIME_ZONE_INFO
  7. | FLUSH cache_type CACHE
  8. [tenant_list] [GLOBAL]
  9. | FLUSH KVCACHE
  10. [tenant] [CACHE [=] cache_name]
  11. cache_type:
  12. ALL
  13. | LOCATION
  14. | CLOG
  15. | ILOG
  16. | COLUMN_STAT
  17. | BLOCK_INDEX
  18. | BLOCK
  19. | ROW
  20. | BLOOM_FILTER
  21. | SCHEMA
  22. | PLAN
  23. tenant:
  24. TENANT [=] tenant_name
  25. cache_name:

RELOAD

  1. alter_system_reload_stmt:
  2. ALTER SYSTEM RELOAD {SERVER | ZONE | UNIT};

REPLICA

  1. alter_system_replica_stmt:
  2. ALTER SYSTEM replica_action;
  3. replica_action:
  4. SWITCH REPLICA
  5. {LEADER | FOLLOWER}
  6. {replica server | server [tenant_name] | zone [tenant_name]}
  7. | DROP REPLICA
  8. replica server [create_timestamp] [zone] [FORCE]
  9. | {MOVE | COPY} REPLICA
  10. replica source destination
  11. | REPORT REPLICA
  12.     {zone | server}
  13.   | RECYCLE REPLICA
  14.     {zone | server}
  15.   | {ALTER | CHANGE | MODIFY} REPLICA  
  16. replica server [set] REPLICA_TYPE = replica_type
  17. source:
  18. SOURCE [=] 'ip:port'
  19. destination:
  20. DESTINATION [=] 'ip:port'
  21. partition_idx | partition_count | table_id | task_id:
  22. INT_VALUE
  23. create_timestamp:
  24. CREATE_TIMESTAMP [=] INT_VALUE
  25. tenant_name_list:
  26. tenant_name [, tenant_name ...]
  27. replica_type:
  28. {FULL | F}
  29. | {READONLY | R}
  30. | {LOGONLY | L}

ROOTSERVICE

  1. alter_system_rootservice_stmt:
  2. ALTER SYSTEM SWITCH ROOTSERVICE {LEADER | FOLLOWER} {zone | server};

ROOTTABLE

  1. alter_system_roottable_stmt:
  2. ALTER SYSTEM CLEAR ROOTTABLE [tenant];

SESSION

  1. alter_system_session_stmt:
  2. ALTER SYSTEM KILL [GLOBAL|LOCAL] [CONNECTION] session_id;
  3. session_id:
  4. INT_VALUE

SERVER

  1. alter_system_server_stmt:
  2. ALTER SYSTEM server_action SERVER ip_port_list [zone];
  3. server_action:
  4. ADD
  5. | DELETE
  6. | CANCEL DELETE
  7. | START
  8. | STOP
  9. | FORCE STOP
  10. ip_port_list:
  11. ip_port [, ip_port ...]

THROTTLE

  1. alter_system_throttle_stmt:
  2. ALTER SYSTEM throttle_action;
  3. throttle_action:
  4. ENABLE SQL
  5. | DISABLE SQL THROTTLE [priority_option] [using_metric_option_list]
  6. priority_option:
  7. FOR PRIORITY <= INT_VALUE
  8. using_metric_option_list:
  9. USING metric_option_list
  10. metric_option_list:
  11. metric_option [metric_option ...]
  12. metric_option:
  13. RT = {INT_VALUE | DECIMAL_VALUE}
  14. | CPU = {INT_VALUE | DECIMAL_VALUE}
  15. | IO = INT_VALUE
  16. | NETWORK = {INT_VALUE | DECIMAL_VALUE}
  17. | LOGICAL_READS = {INT_VALUE | DECIMAL_VALUE}

UNIT

  1. alter_system_unit_stmt:
  2. ALTER SYSTEM MIGRATE
  3. UNIT [=] unit_id DESTINATION [=] ip_port
  4. unit_id:
  5. INT_VALUE

UPGRADE

  1. alter_system_upgrade_stmt:
  2. ALTER SYSTEM upgrade_action;
  3. upgrade_action:
  4. {BEGIN | END} UPGRADE
  5. | UPGRADE VIRTUAL SCHEMA

ZONE

  1. alter_system_zone_stmt:
  2. ADD ZONE zone_name
  3. [zone_option_list]
  4. | {ALTER | CHANGE | MODIFY} ZONE zone_name
  5. [SET] zone_option_list
  6. | {DELETE | START | STOP | FORCE STOP} ZONE zone_name
  7. zone_option_list:
  8. zone_option [, zone_option ...]
  9. zone_option:
  10. region
  11. | idc
  12. | ZONE_TYPE {READONLY | READWRITE}
  13. idc:
  14. STR_VALUE