性能调优

名人博客

• Tom Daly: Sun Demonstrates Compelling Price Performance
• Johan Andersson: Optimizing Queries on MySQL Cluster
• Peter Gulutzan: MySQL Performance Schema
• Anders Karlsson: Using triggers for performance
• Some food for thoughts: How to make use of new SSD devices
• DBT2 MySQL SSD Results
  • http://www.bigdbahead.com/?p=36
  • http://www.bigdbahead.com/?p=43
  • http://www.bigdbahead.com/?p=44
• MySQL and Intel X-25e SSD
  • http://www.bigdbahead.com/?p=518 (Part 1)
  • http://www.bigdbahead.com/?p=532 (Part 1B)
• SSD vs HDD: InnoDB vs MyISAM
• Final Thoughts on SSD and MySQL AKA Battleship Spinn3r

演讲

• Beginner's Guide to Website Performance with MySQL and memcached (ODP)
• Real World Web: MySQL Performance & Scalability
• Distributed
• Innodb Caching with memcached (ODP)
• Performance Guide for MySQL Cluster
• How MySQL.com Improved Their Database Performance with Query
• MySQL Performance on EC2
• Connector/J Performance Gems
• Optimizing MySQL Performance with ZFS
• MySQL Performance Tuning Step-by-Step
• Top 10 MySQL Performance Tips (MySQL Camp I)