MySQL Performance Tuning and Optimization Resources

Benchmarks

• MySQL 5.6 Performance Benchmarks
• MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB
• MySQL Cluster 7.2 Reaches 1 Billion QPM Across Just 8 Intel Servers

White Papers

• What's New in MySQL 5.6
• What's New in MySQL 5.5
• Best Practices Guide: Optimizing the Performance of the MySQL Cluster database
• MySQL Query Analyzer: Overview

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
• SSD Deployment Strategies for MySQL

Presentations

• MySQL - Top 5 Performance Sins
• 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 Analyzer
• MySQL Performance on EC2
• Connector/J Performance Gems

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 Training

• MySQL Performance Tuning

MySQL Consulting

• MySQL Performance Tuning & Optimization

MySQL Query Analyzer

• Product Information
• Try Now

Back to Top