学习mysql manual5.0 Chapter 7. Optimization

1.system bottlenecks系统可能的瓶颈
1.1.Disk seeks磁盘搜索时间,优化查询的一个办法是将数据放到不同的磁盘。
1.2 Disk reading and writing
1.3 CPU cycles
1.4 Memory bandwidth
2.Myisam可能的问题是，它是锁表的,The biggest problem with this storage engine occurs when you have a steady stream of mixed updates and slow selects on a single table
3.Mysql的crash-me可以测量mysql和其他数据库的兼容性。The programs can be found in the sql-bench directory of MySQL source distributions。