MySQL官方的优化建议
Optimizing MySQL
* Choose compiler and compiler options.
(选择编译的方式、编译选项)
* Find the best MySQL startup options for your system.
(针对你的业务系统，选择最好的启动方式)
* Scan the the MySQL manual and read Paul DuBois’ MySQL book.
(翻阅MySQL手册、阅读Paul DuBois的MySQL书籍)
* Use de>EXPLAIN SELECTde>, de>SHOW VARIABLESde>, de>SHOW STATUSde> and de>SHOW PROCESSLISTde>.
(使用命令EXPLAIN,SHOW VARIABLES, SHOW STATUS and SHOW PROCESSLIST)
* Learn how the query optimizer works.
(学习查询优化器的工作原理)
* Optimize your table formats.
(优化你的表)
* Maintain your tables (de>myisamchkde>, de>CHECK TABLEde>, de>OPTIMIZE TABLEde>).
(保养并优化你的表，通过Analyze TABLE,CHECK TABLE,OPTIMIZE TABLE)
* Use MySQL extensions to get things done faster.
(用MySQL提供的扩展去让“效率”更快)
* Write a MySQL UDF function if you notice that you would need some function in many places.
(如果你被通知需要写一些函数，写一些UDF函数)
* Don’t use de>GRANTde> on table level or column level if you don’t really need it.
(如果非必要，请不要对表做很细的grant赋权)
* Pay for MySQL support and get help to solve your problem 
(支付MySQL支持，获得更多的帮助！)
