MySQL [oceanbase]> show parameters where name in ('memory_limit','memory_limit_percentage','system_memory','log_disk_size','log_disk_percentage','datafile_size','datafile_disk_percentage')\G; *************************** 1. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: log_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 2. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: log_disk_size data_type: NULL value: 0M info: the size of disk space used by the log files. Range: [0, +∞) section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 3. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: memory_limit_percentage data_type: NULL value: 90 info: the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 4. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: system_memory data_type: NULL value: 50G info: the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 5. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: memory_limit data_type: NULL value: 0M info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 6. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: datafile_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the data files. Range: [0,99] in integer section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 7. row *************************** zone: zone5 svr_type: observer svr_port: 4882 name: datafile_size data_type: NULL value: 0M info: size of the data file. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 8. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: log_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 9. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: log_disk_size data_type: NULL value: 0M info: the size of disk space used by the log files. Range: [0, +∞) section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 10. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: memory_limit_percentage data_type: NULL value: 90 info: the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 11. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: system_memory data_type: NULL value: 50G info: the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 12. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: memory_limit data_type: NULL value: 0M info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 13. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: datafile_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the data files. Range: [0,99] in integer section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 14. row *************************** zone: zone3 svr_type: observer svr_port: 4882 name: datafile_size data_type: NULL value: 0M info: size of the data file. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 15. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: log_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 16. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: log_disk_size data_type: NULL value: 0M info: the size of disk space used by the log files. Range: [0, +∞) section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 17. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: memory_limit_percentage data_type: NULL value: 90 info: the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 18. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: system_memory data_type: NULL value: 50G info: the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 19. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: memory_limit data_type: NULL value: 0M info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 20. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: datafile_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the data files. Range: [0,99] in integer section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 21. row *************************** zone: zone2 svr_type: observer svr_port: 4882 name: datafile_size data_type: NULL value: 0M info: size of the data file. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 22. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: log_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 23. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: log_disk_size data_type: NULL value: 0M info: the size of disk space used by the log files. Range: [0, +∞) section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 24. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: memory_limit_percentage data_type: NULL value: 90 info: the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 25. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: system_memory data_type: NULL value: 50G info: the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 26. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: memory_limit data_type: NULL value: 0M info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 27. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: datafile_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the data files. Range: [0,99] in integer section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 28. row *************************** zone: zone1 svr_type: observer svr_port: 4882 name: datafile_size data_type: NULL value: 0M info: size of the data file. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 29. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: log_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 30. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: log_disk_size data_type: NULL value: 0M info: the size of disk space used by the log files. Range: [0, +∞) section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 31. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: memory_limit_percentage data_type: NULL value: 90 info: the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 32. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: system_memory data_type: NULL value: 50G info: the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 33. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: memory_limit data_type: NULL value: 0M info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 34. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: datafile_disk_percentage data_type: NULL value: 0 info: the percentage of disk space used by the data files. Range: [0,99] in integer section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE *************************** 35. row *************************** zone: zone4 svr_type: observer svr_port: 4882 name: datafile_size data_type: NULL value: 0M info: size of the data file. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE 35 rows in set (0.01 sec) ERROR: No query specified