从MySQL得到最大的性能
从MySQL得到最大的性能
优化是一项复杂的任务,因为它需要的是对整个系统的理解。当用你的系统/应用做一些局部优化是可能的时候,你越想优化你的系统,你就必须知道也越多。
因此,本章将试图解释并给出优化MySQL的不同方法的一些例子。但是记住总是有某些(逐渐变难)是系统更快的方法故意留着去做的。
优化概述
为了使一个系统更快的最重要部分当然是基本设计。你也需要知道你的系统将做这样的事情,那就是你的瓶颈。
Getting maximum performance from MySQL
Optimization is a complicated task since it ultimately requires understanding of the whole system. While it may be possible to do some local optimizations with small knowledge of your system/application, the more optimal you want your system to become the more you will have to know about it.
So this chapter will try to explain and give some examples of different ways to optimize MySQL. But remember that there are always some (increasingly harder) ways to make the system even faster left to do.
8300字