We have been receiving alerts of IMPALAD_FRONTEND_CONNECTIONS becoming bad "There are 0 (Beeswax pool) 55 (Hive Server 2 pool) active client connections, each pool has a configured maximum of 64"
Impala Daemon Concurrent Client Connections Monitoring Percentage Thresholds
Warning = 80
Critical = 95
Impala Daemon Max Client Connections = 64
CM - 5.16.2
CDH - 5.16.2
Will increasing Impala Daemon Max Client Connections reduce / stop these alerts? Any help is most welcome.
Thanks for your reply, post your reply, I have more questions than answers 🙂
1) Is there a way to find if impala deamon can handle additional connections (from default 64 to 128 and more)
2) Can we find the number of connections that are made in real time? (Apart from Active Frontend API Connections Chart)
3) How are connection closed (i.e. are they closed once an impala query is completed or is there some other process)
4) Any best practice recommendation for Swap Memory setting in Impala.
Seems like your cluster is configured with default impala admission control control. Please create and setup new impala admission control control with the correct parameter based on the how much queries need to executed and resources you have