title: Website slow response (all other users) when large MySQL query running
body: <p>This may seem like an obvious question but we have a PHP/MySQL app that runs on Windows 2008 server. The server has about 10 different sites running from it in total. Admin options on the site in question allow an administrator to run reports (through the site) which are huge and can take about 10mins in some cases. These reports are huge mysql queries that display the data on screen. When these reports are running the entire site goes slow for all users. So my questions are:</p>
  
  <ul>
  <li>Is there a simple way to allocate server resources so if a (website) administrator runs reports, other users can still access the site without performance issues?</li>
  <li>Even though running the report kills the website for all users of that site, it doesn't affect other sites on the same server. Why is that?</li>
  <li>As mentioned, the report can take about 10 minutes to generate - is
  it bad practice to make these kinds of reports available on the
  website? Would these typically be generated by overnight scheduled tasks?</li>
  </ul>
  
  <p>Many thanks in advance.</p>