View Single Post
  #3 (permalink)  
Old 09-19-2008, 03:59 AM
BillPrice BillPrice is offline
WebProWorld New Member
 

Join Date: Sep 2008
Posts: 3
BillPrice RepRank 0
Default Re: How to Kill MySQL Sleep ?

hey man i have the same problem like this

i've a problem with sleep processes in my mysql database. Some longe queries cause sleeping processes if the user break up before result is on the screen. There isnt yet a posibility to speed up the queries so the only way to avoid a breakdown of the system because of to many sleeping ones is to kill them after the slept for 2 min. Till now the run for 943 sek which is way to long.
__________________
Folder Printing Sticker Printing
Reply With Quote