0133.O OceanBase社区版clog使用空间调整

[admin@ob03 store]$ df -h | grep home
/dev/mapper/centos-home  1.8T  1.4T  357G  80% /home

[admin@ob03 store]$ du -sh *
789G  clog      #clog存放目录，占用空间较大
4.1G  ilog
145M  slog
623G  sstable    #数据存放目录

- name: clog_disk_usage_limit_percentage
  require: false
  type: INT
  default: 95
  min_value: 80
  max_value: 100
  section: TRANS
  need_restart: false
  description_en: maximum of clog disk usage percentage before stop submitting or receiving logs.
  description_local: 事务日志的磁盘IO最大可用的磁盘利用率

[admin@obp1 ~]$ obd cluster edit-config obcluster      #添加参数，将clog磁盘空间使用率默认值80%降低为30%
  global:
...
    clog_disk_utilization_threshold: 30
...

[admin@obp1 ~]$ obd cluster reload obcluster
Get local repositories and plugins ok
Load cluster param plugin ok
Open ssh connection ok
Cluster status check ok
Connect to obproxy ok
Connect to observer ok
obcluster reload

MySQL [oceanbase]> show parameters like 'clog_disk_utilization_threshold';
+-------+----------+---------------+----------+---------------------------------+-----------+-------+---------------------------------------------------------------------------------------------------------------------------------+---------+---------+---------+-------------------+
| zone  | svr_type | svr_ip        | svr_port | name                            | data_type | value | info                                                                                                                            | section | scope   | source  | edit_level        |
+-------+----------+---------------+----------+---------------------------------+-----------+-------+---------------------------------------------------------------------------------------------------------------------------------+---------+---------+---------+-------------------+
| zone1 | observer | 192.168.8.242 |     2882 | clog_disk_utilization_threshold | NULL      | 30    | clog disk utilization threshold before reuse clog files, should be less than clog_disk_usage_limit_percentage. Range: [10, 100) | TRANS   | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
| zone3 | observer | 192.168.8.244 |     2882 | clog_disk_utilization_threshold | NULL      | 30    | clog disk utilization threshold before reuse clog files, should be less than clog_disk_usage_limit_percentage. Range: [10, 100) | TRANS   | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
| zone2 | observer | 192.168.8.243 |     2882 | clog_disk_utilization_threshold | NULL      | 30    | clog disk utilization threshold before reuse clog files, should be less than clog_disk_usage_limit_percentage. Range: [10, 100) | TRANS   | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+---------------+----------+---------------------------------+-----------+-------+---------------------------------------------------------------------------------------------------------------------------------+---------+---------+---------+-------------------+
3 rows in set (0.116 sec)

[admin@ob01 store]$ du -sh *
768G  clog
4.0G  ilog
96M  slog
623G  sstable
[admin@ob01 store]$ du -sh *
550G  clog
2.8G  ilog
96M  slog
623G  sstable
[admin@ob03 store]$ du -sh *
64M  clog              #clog目录有768G大幅下降为64M
1.1M  ilog
269M  slog
623G  sstable

clog目录只剩余1个文件，文件编号以19497开头
[admin@ob02 store]$ ls clog/
19497
[admin@ob02 clog]$ ls -lrt | grep -v total | head -n1
-rw-r--r-- 1 admin admin 67108864 Feb 10 10:25 19497

[admin@ob03 store]$ df -h | grep home
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/centos-home  1.8T  631G  1.2T  36% /home

MySQL [oceanbase]> SELECT DATE_FORMAT(gmt_create, '%b%d %H:%i:%s') gmt_create_ , module, event, name1, value1, name2, value2, rs_svr_ip,name3,value3,name4,value4
    -> FROM __all_rootservice_event_history
    -> WHERE  module IN ('root_service')
    -> and event='admin_set_config'
    -> ORDER BY gmt_create DESC
    -> LIMIT 10;
+----------------+--------------+------------------+-------+--------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-------+--------+-------+--------+
| gmt_create_    | module       | event            | name1 | value1 | name2 | value2                                                                                                                                                                 | rs_svr_ip     | name3 | value3 | name4 | value4 |
+----------------+--------------+------------------+-------+--------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-------+--------+-------+--------+
| Feb10 09:43:41 | root_service | admin_set_config | ret   | 0      | arg   | {items:[{name:"clog_disk_utilization_threshold", value:"30", comment:"", zone:"", server:"0.0.0.0", tenant_name:"", exec_tenant_id:1, tenant_ids:[]}], is_inner:false} | 192.168.8.242 |       |        |       |        |
| Feb09 11:15:24 | root_service | admin_set_config | ret   | 0      | arg   | {items:[{name:"datafile_disk_percentage", value:"35", comment:"", zone:"", server:"0.0.0.0", tenant_name:"", exec_tenant_id:1, tenant_ids:[]}], is_inner:false}        | 192.168.8.242 |       |        |       |        |
+----------------+--------------+------------------+-------+--------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-------+--------+-------+--------+
2 rows in set (0.012 sec)