The Data Guy

WLM Max connection hit

RStoolKit Result: WLM max connection hit

RedShift is an OLAP database system. It support upto 500 connections. But only 50 allowed to run concurrently. If you are hitting more connections means sometimes its fine but something you are accessing it as an Transactional database which is bad. Even if you hit more connections, but your WLM is well tunned then you don’t need to worry about this.

Find the Max connection hit hour:

You can use the RedShift Admin script to figure out what is your peak hour(when you are getting more number of connections).

This is a CPU intensive query, single node cluster will consumpe full CPU. so please run this during non production hours, or closly monitor the cluster.

Run the wlm_apex_hourly.sql query.

/assets/rskit/highconnection.png

From the above result, you can see my peak hour is 21 to 23. During this window Im getting more number of connections.

How to fix this problem:

Actually there is no fix for this. More connections are find. But remember 500 is the hard limit in RedShift. But you can optimize this to quickly run and exit from the cluster.

  1. WLM - System tables and views
  2. RedShift QMR rules
  3. Optimizing WLM
· aws, redshift, rstoolkit

Advertisement


Loading Comments