"OceanBase数据库中使用source命令导入sql会中断是怎么回事?并且中断后必须重启observer才可以,问题出在哪里?
就是使用source导入sql 文件,文件大小100多兆,但是导入部分就中段了。"
"select a.zone, a.SVR_IP,a.SVR_PORT, b.status,
cpu_capacity,cpu_assigned_max,cpu_capacity-cpu_assigned_max as cpu_free,
round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,
round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,
round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,
round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,
round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,
round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,
round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,
round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_gb,
round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,
round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb
from gv$ob_servers a join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G; 看一下
参考https://ask.oceanbase.com/t/topic/35601177
此回答整理至钉群“[社区]技术答疑群OceanBase”"
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。