title: How can I kill MySQL queries or sleeping connections every 60 seconds in Windows?
body: <p>I want to check my MySQL server every minute and kill queries that have run longer than 150 seconds. The main reason I want to do this is because I don't want queries from certain people to lock up the DB for everyone else. I know this is not the ultimate solution to the problem, but at least it's a fallback in case something goes wrong with a query. I don't have a slave DB (this is just an at-home project).</p>
  
  <p>I'd like to schedule a script to run that does this for me. I'm unfamiliar with Perl or Ruby and I need it done on my Windows 2008 Server box. I've looked into creating a simple cmd line script, but that doesn't seem to be possible. I know currently I can do something like this but I have to do it manually:</p>
  
  <pre><code>mysqladmin processlist
  mysqladmin kill
  </code></pre>
  
  <p>Anyone have any ideas or examples on how I could do this?</p>