I have a new Ubuntu 64 bits server which should be used for MySQL only. The version of MySQL is 5.1.37.
I would like to know what is the best place to learn on how fine tune this server to receive the most number of connection while being fast and effective.
There is a package in Ubuntu called mysqltunner which is a PERL script written for that purprose.
Can anyone make me any good recommendations regarding this issue?