| 失效链接处理 |
|
MySQL Server and SQL Performance Tuning PDF 下载
本站整理下载：
相关截图：
主要内容：
Cover the main steps
– Show at least one example for each step
– Examples are things I run into most commonly in
the field
– Include links to MySQL manual for additional
information
This will be technical
Most everything you need comes with MySQL!
You cannot become a performance tuning wizard in
45 minutes - PT Class is 4 day class
http://www.mysql.com/training/courses/ performance_tuning.html
MySQL Performance Forum
http://forums.mysql.com/list.php?24
• Pre 5.5 – No real scale up
• Now with 5.5 we scale up into 64 cores
• x86_64 - 64 bit for more memory is important
• Linux or Solaris best, Windows and Unix also fine
• Big gains on Windows with 5.5
• RAID 10 for most, RAID 5 OK if very read intensive
• Hardware RAID battery backed up cache critical!
- More disks are always better!
- 4+ recommended, 8-16 can increase IO performance if needed
• Memory should be at least 1/3 to 1/10 data size
- The more, the better
|
苏公网安备 32061202001004号
