I am doing load testing on our API that has MYSQL as DB and SPRING BOOT as framework.
i have done custom configuration of MYSQL for my API.
As i am using AWS RDS for mysql, on load test i have observed that
HikariConfig.getConnection() is taking around 91% of response time on load.
I have made two mysql connections, one for READ and one for WRITE.
This is my Configuration for HIKARICP for write and same is for read also:
Can anyone help me out regarding this, as i want to reduce time for HikariConfig.getConnection().