Posted by arun ak on December 16, 2016 at 9:15am
In my drupal 8 website I am facing one issue with the performance. Load test is getting failed because of too many connections comming to the database. I am having separate DB server for database.
For 500 concurrent users around 200 - 300 db connections are comming. For 1200 concurrent users around 800 - 1000 db connections.
As Drupal is a db intensive system, above mentioned counts are ok with its normal behaviour or something weird is happening in this case?
Comments
DB load
With modern MySQL (5.6+) the number of open connections usually doesn't have a huge impact on the performance of the DB. What influences it are the current active queries and any open transactions. Do you know what is failing when you load test? SHOW PROCESSLIST is a good way to get a quick snapshot of what might be causing the DB problem.