title: MySQL Server performance
body: <p>I have a few questions regarding MySQL server running under Windows Server 2008 R2.</p>
  
  <p>1) How do I check the number of allowed connections?</p>
  
  <p>2) How do I turn on query logging to see performance of queries executed?</p>
  
  <p>3) As I understand MySQL is multithreaded, will increasing the number of allowed connections increase performance on a Quad Core system?</p>
  
  <p>4) Will having a cluster setup increase performance?</p>
  
  <p>5) How can I setup load shedding with multiple MySQL servers in a cluster?</p>
  
  <p>Thanks</p>