【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】OceanBase4.3
【问题描述】demo版本的clog已经有1.5T。可以关闭clog,或者有什么办法清理吗
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查[root@localhost cs_info_dw.dwd_company_basic]# obd cluster display demo
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect to observer 127.0.0.1:2881 ok
Wait for observer init ok
±--------------------------------------------+
| observer |
±----------±--------±-----±------±-------+
| ip | version | port | zone | status |
±----------±--------±-----±------±-------+
| 127.0.0.1 | 4.3.0.1 | 2881 | zone1 | ACTIVE |
±----------±--------±-----±------±-------+
obclient -h127.0.0.1 -P2881 -uroot -p’E0QIJt7RE2z0sxvtvyJZ’ -Doceanbase -A
Connect to obproxy ok
±--------------------------------------------+
| obproxy |
±----------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±----------±-----±----------------±-------+
| 127.0.0.1 | 2883 | 2884 | active |
±----------±-----±----------------±-------+
obclient -h127.0.0.1 -P2883 -uroot -p’E0QIJt7RE2z0sxvtvyJZ’ -Doceanbase -A
Connect to Obagent ok
±-------------------------------------------------------------+
| obagent |
±----------±-------------------±-------------------±-------+
| ip | mgragent_http_port | monagent_http_port | status |
±----------±-------------------±-------------------±-------+
| 127.0.0.1 | 8089 | 8088 | active |
±----------±-------------------±-------------------±-------+
Connect to Prometheus ok
±-------------------------------------------------+
| prometheus |
±----------------------±-----±---------±-------+
| url | user | password | status |
±----------------------±-----±---------±-------+
| http://127.0.0.1:9090 | | | active |
±----------------------±-----±---------±-------+
Connect to grafana ok
±----------------------------------------------------------------+
| grafana |
±----------------------------------±------±-----------±-------+
| url | user | password | status |
±----------------------------------±------±-----------±-------+
| http://127.0.0.1:3000/d/oceanbase | admin | VnDhRmUJOj | active |
±----------------------------------±------±-----------±-------+
obclient [oceanbase]> select * from __all_virtual_server;
±----------±---------±------±---------±-------------±-----------------±-------------±-----------------±-------------±-------------±-------------------±-----------------±------------------------±------------------------±------------------±------------------±----------------±----------------------±-------------±--------------------+
| svr_ip | svr_port | zone | sql_port | cpu_capacity | cpu_capacity_max | cpu_assigned | cpu_assigned_max | mem_capacity | mem_assigned | data_disk_capacity | data_disk_in_use | data_disk_health_status | data_disk_abnormal_time | log_disk_capacity | log_disk_assigned | log_disk_in_use | ssl_cert_expired_time | memory_limit | data_disk_allocated |
±----------±---------±------±---------±-------------±-----------------±-------------±-----------------±-------------±-------------±-------------------±-----------------±------------------------±------------------------±------------------±------------------±----------------±----------------------±-------------±--------------------+
| 127.0.0.1 | 2882 | zone1 | 2881 | 16 | 16 | 12 | 12 | 41225814016 | 40802189312 | 3400777334784 | 17634951168 | NORMAL | 0 | 1503238553600 | 2147483648 | 1744830464 | 0 | 43452989440 | 21474836480 |
±----------±---------±------±---------±-------------±-----------------±-------------±-----------------±-------------±-------------±-------------------±-----------------±------------------------±------------------------±------------------±------------------±----------------±----------------------±-------------±--------------------+
1 row in set (0.001 sec)
obclient [oceanbase]> select * from gv$ob_units;
±----------±---------±--------±----------±------±----------±-----------±--------±--------±------------±--------------------±--------------------±------------±--------------±----------------±-----------------±-------±---------------------------+
| SVR_IP | SVR_PORT | UNIT_ID | TENANT_ID | ZONE | ZONE_TYPE | REGION | MAX_CPU | MIN_CPU | MEMORY_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | LOG_DISK_SIZE | LOG_DISK_IN_USE | DATA_DISK_IN_USE | STATUS | CREATE_TIME |
±----------±---------±--------±----------±------±----------±-----------±--------±--------±------------±--------------------±--------------------±------------±--------------±----------------±-----------------±-------±---------------------------+
| 127.0.0.1 | 2882 | 1 | 1 | zone1 | ReadWrite | sys_region | 12 | 12 | 40802189312 | 9223372036854775807 | 9223372036854775807 | 3 | 2147483648 | 1664037735 | 17575538688 | NORMAL | 2024-05-08 17:05:23.837877 |
±----------±---------±--------±----------±------±----------±-----------±--------±--------±------------±--------------------±--------------------±------------±--------------±----------------±-----------------±-------±---------------------------+
1 row in set (0.003 sec)