how can i optimize my mysql ?

[meeti]

Hi,

my server has some forums on it,

and it need mysql with php to run,

i want to optimize the mysql to get better performance,



can anyone teach how can i check it my setting is ok and how can i do?



thanks

[jayh38]

This script is available. Although you might want to leave your mysql running 48 hrs as recommended first.

[meeti]

Hi,


as usual,

when i edit the file /etc/my.cnf,

all the mysql setting will run as it write with?



after editing,should i restart the mysql?



thanks

[jayh38]

After editing my.cnf, yes you will need to restart mysql for the configuration to load. Providing your settings are correct, mysql should restart just fine. If not, then obviously you have invalid settings.