dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Sleep state in mysql

  1. #1
    Join Date
    Feb 2004
    Location
    Brasil porto Aelgre
    Posts
    544

    Sleep state in mysql

    Hi

    I have many querys in sleep state consuming connections what the meaning of the sleep connections? they are waiting for what ?

    Thank s in advance

  2. #2
    Join Date
    Jul 2010
    Location
    /ramdisk/
    Posts
    865
    Mysql sleeping connections are connections established but never exited. It's a persistent connection.

    The application connecting to the database should, in a server admin utopia, say when it's done querying and close the connection. If it doesn't you can restrict their maximum connection # and force them to (if they're willing to cooperate). You can also decrease the timeout for connections.

    The sleeping connections will take up some system resources, but they may actually be using them. In some rare cases it isn't a bad idea. It could also show that an application is misusing/abusing the connection space and should be fixed.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles