MySQL show processlist; a lot of sleep command

Show Processlist; Looking at the next, we found that there are 10 rows, which means 10 database connections are not closed? Can you just end the command for sleep? Using PHP to connect to the database requires each call plus mysql_close (), I read the manual said no need, really?

Reply content:

Show Processlist; Looking at the next, we found that there are 10 rows, which means 10 database connections are not closed? Can you just end the command for sleep? Using PHP to connect to the database requires each call plus mysql_close (), I read the manual said no need, really?

Brother, read this article http://blog.chinaunix.net/uid-134240-id-220211.html as long as you put the connection in the code, you don't have to be afraid, of course, if you add a connection pool, you do not have to tube. This blog is believed to have what you want.

The first column of show Processlist is the ID, and you can execute the kill ID directly to kill the corresponding thread.

