发现将集群配置参数cpu_count改成0后isdefault 显示1 而cpu_count改成1后isdefault 显示0,1是默认 0不是默认,是这样理解么?
obclient(root@sys)[oceanbase]> ALTER SYSTEM SET cpu_count=0;
Query OK, 0 rows affected (0.075 sec)
obclient(root@sys)[oceanbase]> show parameters like ‘cpu_count’;
±------±---------±---------------±---------±----------±----------±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault |
±------±---------±---------------±---------±----------±----------±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone1 | observer | 192.168.40.110 | 2882 | cpu_count | INT | 0 | the number of CPU’s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 |
±------±---------±---------------±---------±----------±----------±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
1 row in set (0.009 sec)
obclient(root@sys)[oceanbase]> SELECT SVR_IP,CPU_CAPACITY FROM GV$OB_SERVERS WHERE SVR_IP=‘192.168.40.110’;
±---------------±-------------+
| SVR_IP | CPU_CAPACITY |
±---------------±-------------+
| 192.168.40.110 | 2 |
±---------------±-------------+
1 row in set (0.007 sec)
obclient(root@sys)[oceanbase]> ALTER SYSTEM SET cpu_count=1;
Query OK, 0 rows affected (0.039 sec)
obclient(root@sys)[oceanbase]> show parameters like ‘cpu_count’;
±------±---------±---------------±---------±----------±----------±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault |
±------±---------±---------------±---------±----------±----------±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone1 | observer | 192.168.40.110 | 2882 | cpu_count | INT | 1 | the number of CPU’s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 |
±------±---------±---------------±---------±----------±----------±------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
1 row in set (0.007 sec)
obclient(root@sys)[oceanbase]> SELECT SVR_IP,CPU_CAPACITY FROM GV$OB_SERVERS WHERE SVR_IP=‘192.168.40.110’;
±---------------±-------------+
| SVR_IP | CPU_CAPACITY |
±---------------±-------------+
| 192.168.40.110 | 1 |
±---------------±-------------+
1 row in set (0.005 sec)