Hi Team ,    I am having issues while connecting to mysql database using apache nifi.  The error is as follows Cannot create PoolableConnectionFactory   Please note that Apache Nifi and MySQL is installed on the same Linux server and hence there shouldn't be any problems with the 2 applications talking to each other.    The database connection pool settings is provided below   The error when I try extracting the records is provided below     This is something very urgent as we are doing a POC and if this succeeds our Projects will be based on this. Any help in this regard will be much appreciated.    @Matt @Shu  ... View more

Hi Team ,    I need some advice on how to tune our Nifi Cluster. We have a 3 Node Nifi Cluster that processes events in a real time streaming fashion which means our flows are running 24 by 7 . Each of the Nifi Linux servers have a RAM of 31GB. We have set the JVM memory setting in the bootstrap conf file to 28 G.    #JVM memory Settings java.arg.2=-Xms28G java.arg.3=-Xms28G   However when I run a free -h command on the servers this is what I get which clearly shows that the used Memory is 30 G.      As a result of this , we keep getting incidents raised from the Linux team stating that the Nifi servers are always hovering over the  95 % mark and on top of that if any processor in the flow starts misbehaving , it shoots up to 100 percent and the server goes unresponsive.    So my question is , even after setting the threshold to 28 G in the bootstrap conf file , why do we still see Nifi taking up almost all the memory allocated to the server ?    @Matt    ... View more