• Home
  • Blog
  • MySQL: Are sleep connections an issue?

MySQL: Are sleep connections an issue?

I've being working with MySQL since 1994. Yes, too much time to count. Let it go.

Sleep Connections right? Also called idle connections. One used to call the annoying connections.

First of all the max_connections variables. That's the limit of manageable connections that your server will do. If you set the max_connections to 100 for example, no 101 connections will be allowed. If the server are maintaining open connections never being taken again that's an issue to be addressed. Tons of connections to database, normally, tells me that the application is faulty or the application wasn't well designed. Very specific applications really needs to open several connections. Come on! Use pools of connections for god sake.

Keep in mind that each idle connection has a minimum consumption of resources such as memory for example. The minimum memory connection is about 192kb to 256kb. But it depends what happening when the connection was broken.

What can lead to a sleep connection?

  • Bad handshaking
  • Network failure
  • Application failure
  • Connection manager failure
  • Programming misconception

If you see a lot of connections sleeping at your MySQL Server you must spend sometime investigating it. The dbsnOOP provide means to track it down and helpful tools to fight idle connections.

 

Social causes we support

Social causes we support

Our achievements are our efforts

About us

dbsnOOp is a company established in Brazil and founded by the database guru creator of alejuice, alemonitor, alebackup, and aletools. A company focused on database consultancy services and support based on high level and deep knowledge, honor, and respect.

Contact us

  • Este endereço de email está sendo protegido de spambots. Você precisa do JavaScript ativado para vê-lo.