mysql怎么杀掉sleep进程,如何在Mysql中删除sleep进程

I found that my mysql sever have many of connection who is sleep. i want to delete them all.

so how i can configure my mysql server than then delete or dispose the connection who is in sleep not currently in process.

are this possible to delete this thing in mysql tell me how i can do following

a connection allow only one time datareader open and destroy the connection [process] after giving resposnse of query.

解决方案

Why would you want to delete a sleeping thread? MySQL creates threads for connection requests, and when the client disconnects the thread is put back into the cache and waits for another connection.

This reduces a lot of overhead of creating threads 'on-demand', and it's nothing to worry about. A sleeping thread uses about 256k of memory.