MySQL Server performance
I have a few questions regarding MySQL server running under Windows Server 2008 R2.

1) How do I check the number of allowed connections?
2) How do I turn on query logging to see performance of queries executed?
3) As I understand MySQL is multithreaded, will increasing the number of allowed connections increase performance on a Quad Core system?
4) Will having a cluster setup increase performance?
5) How can I setup load shedding with multiple MySQL servers in a cluster?

Thanks
MySQL Server performance
===

I have a few questions regarding MySQL server running under Windows Server 2008 R2.

1) How do I check the number of allowed connections?
2) How do I turn on query logging to see performance of queries executed?
3) As I understand MySQL is multithreaded, will increasing the number of allowed connections increase performance on a Quad Core system?
4) Will having a cluster setup increase performance?
5) How can I setup load shedding with multiple MySQL servers in a cluster?

Thanks