0

Good day to all. I have a little problem:

How do I close the sleeping connections to a database?

When I issue a query the query is executed then the connection remains on sleep mode for 2-3 seconds. The problem is that I generate queries faster than they are closed.

Is there a way to force a connection to close before entering in the sleep mode? Or any workaround.

Thank you for help.

Note: The connections are not permanent, they close, but just to slow... Note 2 - for the mysql_close(): The command is issued at the end of the query. Still the query goes into sleep mode before close. I attach a print screen in a min.

enter image description here

Notice the sleeping connections... they will be closed in 1-3 secs... but I generate another queries faster. I need to skip the sleep wasted time.

zozo
  • 8,230
  • 19
  • 79
  • 134

4 Answers4

1

Are you using mysql_pconnect() ? If not, this should not happen if you properly close every connection made to your database.

Edit : Similar issue ?

Community
  • 1
  • 1
Dalmas
  • 26,409
  • 9
  • 67
  • 80
0

Try setting the wait_timeout variable = 1 so they will close after 1 second.

Joshua
  • 3,465
  • 3
  • 28
  • 19
0

Explicitly. For example, if you are using mysql then call mysql_close(). Or the equivalent for whatever database you are using.

David Gillen
  • 1,172
  • 5
  • 14
0

my class for dbconnection hast mysqli_close($this->conn); in its __destruct() so that every connection is closed on destruction of the connection.

DKSan
  • 4,187
  • 3
  • 25
  • 35