MySQL Performance Tuning and Optimization Resources

Benchmarks

• MySQL/Sun set World Record SPECJ Benchmark
• MySQL Cluster 7.0 now scales linearly in two dimensions with more than 4 times more transactional throughput!
• Performance Impacts of On-Line Add Node Operations

Webinars (On Demand)

• MySQL Cluster Performance Tuning Best Practices
• MySQL Performance Tuning Step-by-step
• MySQL Performance Tuning: Top 5 Tips
• MySQL Performance Tuning Best Practices
• MySQL Coding and Indexing Strategies for Optimal Performance

White Papers

• Boosting MySQL Performance and Scalability with the InnoDB Plugin
• Best Practices Guide: Optimizing the Performance of the MySQL Cluster database
• MySQL Performance Benchmarks - Measuring MySQL’s Scalability and Throughput
• MySQL Query Analyzer: Monitoring Applications for Problem Queries

Blogs

• Johan Andersson: Optimizing Queries on MySQL Cluster
• 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

Presentations

• 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
• MySQL Performance Tuning Step-by-Step

Case Studies

• Clickability Dramatically Improves Performance and Scalability with MySQL Query Analyzer
• thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
• Big Fish Games Triples Database Performance with MySQL Query Analyzer
• MySQL Performance Tuning Tips for Commercial Application Developers

MySQL Training

• MySQL Performance Tuning
• MySQL Performance Tuning Bootcamp

MySQL Consulting

• MySQL Performance Tuning & Optimization

MySQL Query Analyzer

• Product Information
• Demo
• 30 Free Trial

Back to Top