mysql optimization

about mysql optimization:
http://dev.mysql.com/doc/mysql/en/Optimizing_the_Server.html
http://jeremy.zawodny.com/mysql/mysql-optimization.html
http://www.phpexamples.net/mysqlman/manual_MySQL_Optimization.html
http://codenode.com/optimizemysql