AWS RDS Aurora MySQL 5.7.12 Query Performance

In a recent customer scenario we encountered some unexpected performance issues when connecting to a AWS RDS Aurora MySQL 5.7.12  as data source. Data Connection was slow and also the queries in a Direct Access were very slow.

After some digging in the AWS documentation we found two parameters that can have a significant influence on on the Connection and Query Performance. As they are NOT compatible with Aurora

usePipelineAuth

when usePipelineAuth is enabled (active by default), Queried that are send using pipeline (all queries sent, then all results are read) this normally allows a faster connection creation, but is not compatible with Aurora.

useBathMultisend

also useBathMultisend is active on default and will send queries in Batch. But is not compatible with Aurora.

So, how do you turn off the two variables, and avoid them to caus slow connection; we expirenced the response time and connectivity to improve significantly

In your Pyramid Installation

Admin>data>Data sources>MySQL

?usePipelineAuth=false&useBatchMultiSend=false

Now the Parameters are switched off and the performance on Aurora should improve.