title: Anyway to Limit MySQL Query Execution time?
body: <p>Hi I'm having issues on my server at the minute because some of the MySQL queries are taking a very long time to run, and hogging the resources on the server.</p>
  
  <p>I'm already in the process of optimising all the queries to improve the performance, but as we use a fair amount of 3rd party applications on the server using mysql I was hoping to put in place a safeguard to prevent future issues.</p>
  
  <p>What I need is something I can put in place server wide that will apply to all queries but with the possibility of overriding it on a per query basis for some of the more complex reports that do take some time to run.</p>
  
  <p>I've spent time googling to find a solution but so far no luck,</p>
  
  <p>Thanks for your help</p>