YMatrix
Quick Start
Connecting
Benchmarks
Deployment
Data Usage
Manage Clusters
Upgrade
Global Maintenance
Expansion
Monitoring
Security
Best Practice
Technical Principles
Data Type
Storage Engine
Execution Engine
Streaming Engine(Domino)
MARS3 Index
Extension
Advanced Features
Advanced Query
Federal Query
Grafana
Backup and Restore
Disaster Recovery
Guide
Performance Tuning
Troubleshooting
Tools
Configuration Parameters
SQL Reference
mxstate # Display cluster status
mxstate -s # Display the status of the entire YMatrix cluster
mxstate -m # List mirror segments
mxstate -f # Display standby master informationDisplay configuration values:
gpconfig -s {GUC}
# Example: View the maximum allowed number of connections
gpconfig -s max_connectionsModify configuration values:
gpconfig -c {GUC} -v {Value} -m {Value} # -m specifies the value for the master node; -v specifies the value for segment nodes
gpconfig -c {GUC} -v {Value} # If -m is omitted, the master node uses the same value as the segments
# Examples:
gpconfig -c max_connections -v 1000 -m 300
gpconfig -c shared_buffers -v 2GBFor more information, see Basic Cluster Management.