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 EXPLAIN SELECT, SHOW VARIABLES, SHOW STATUS and SHOW PROCESSLIST.
  (使用命令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支持，获得更多的帮助！)