lot of mysql sleep threads.

[benito]

Since last weekends i see an excesive ammount of sleep threads on mysql. How can i limit the sleep threads ?

[benito]

I looked into that variable, i got 300 there. But the strange thing is that mytop shows me queries with more than 300 secs.

Now i will see how it works with 60.

Add the following under [mysqld] in your /etc/my.cnf

wait_timeout = 60

Change the 60 as you see fit