0

We have a problem when applying stress test (sending too many users in the same time) to our application, our application trying to create new connections to serve users, but azure Mysql DB service is generating a lot of failed connections.

Azure Failed connections diagram

even the CPU usage of DB server is as the Azure diagram is less than 10 percent.

Azure Mysql DB CPU usage

I'm thinking that the problem is because the default server parameters is not optimal here are some of these parameters

Azure Server Parameter

any Ideas?

Nico Haase
  • 11,420
  • 35
  • 43
  • 69
J Doe
  • 3
  • 1
  • 3

1 Answers1

1

There is a limit on the number of connections per pricing tier. For instance, a Basic tier with 1 vCore allows a maximum of 50 connections, while a Basic tier with 2 vCore allows a maximum of 100 connections. Please read this documentation for more details.

enter image description here

Dave Anderson
  • 11,836
  • 3
  • 58
  • 79
Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
  • we have a 32 vCore which means we should have 5000 connections, but it served about 100 connections and generate about 2500 failed connections – J Doe Aug 30 '18 at 13:23
  • The .NET MySQL data provider supports advanced connection pooling. Are you using it? https://www.devart.com/dotconnect/mysql/docs/ComparingProviders.html – Alberto Morillo Aug 30 '18 at 14:17
  • no actually the problem was in our application, we used "pdo persistent connection" and it worked i don't know if it has some disadvantage but it solved the problem. – J Doe Aug 31 '18 at 15:36
  • Please consider to add your solution as an answer. – Alberto Morillo Aug 31 '18 at 16:09