Skip to main content

Cluster Management

  • October 29, 2013
  • 1 reply
  • 7 views

Akilesh_K
How can we know that which node in the cluster is giving better performance?

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • October 31, 2013
All the nodes should have the same configuration, so all of them should have the same performance. If this is not the case, probably 
1- You have the data skewed ( you can check projection_storage table to see that)
2- You are not using a load balancer and all your queries go to same initiator ( you can check query_profiles and check the node_name column and see if the data is distributed)
Hope this helps, 
Eugenia