GreatDB系统参数调整

GreatDB SqlNode参数调整

• 示例，SqlNode 所有节点调整 max_connections 参数值

[root@greatdb1 ~]# greatsql -ugreatdb -pgreatdb -h192.168.0.81 -P3306

GreatDB Cluster[(none)]> select * from information_schema.greatdb_SqlNode_variables where variable_name='max_connections';
+-------------------+-----------------+----------------+
| SQLNODE           | VARIABLE_NAME   | VARIABLE_VALUE |
+-------------------+-----------------+----------------+
| 192.168.0.81:3306 | max_connections | 2000           |
| 192.168.0.82:3306 | max_connections | 2000           |
| 192.168.0.83:3306 | max_connections | 2000           |
+-------------------+-----------------+----------------+
3 rows in set (0.14 sec)

GreatDB Cluster[(none)]> CALL mysql.greatdb_set_var_for_all_SqlNodes('max_connections',1000,true);
Query OK, 1 row affected (0.04 sec)

GreatDB Cluster[(none)]> select * from information_schema.greatdb_SqlNode_variables where variable_name='max_connections';
+-------------------+-----------------+----------------+
| SQLNODE           | VARIABLE_NAME   | VARIABLE_VALUE |
+-------------------+-----------------+----------------+
| 192.168.0.81:3306 | max_connections | 1000           |
| 192.168.0.82:3306 | max_connections | 1000           |
| 192.168.0.83:3306 | max_connections | 1000           |
+-------------------+-----------------+----------------+
3 rows in set (0.14 sec)
				
	
	

		
相关文章