MySQL Performance Tuning and Optimization Resources
White Papers
- What’s New in MySQL 5.7
- MySQL Cluster 7.4: New Features for Internet-Scale Performance with Carrier-Grade Availability
- Guide to Optimizing Performance of the MySQL Cluster Database
- Oracle Linux and MySQL TPC-C Optimizations When Implementing the Sun Flash Accelerator F80 PCIe Card
- MySQL Fabric - A Guide to Managing MySQL High Availability & Scaling Out More (10) »
- Performance Advantages of Running an Oracle® MySQL Replicated Database on Oracle Linux with Oracle’s Sun Flash Accelerator F80 PCIe Card
- MySQL Replication Tutorial: Configuration, Provisioning and Management
- MySQL Replication: High Availability - Building a Self-Healing Replication Topology
- DBA and Developer Guide to What's New in MySQL 5.6
- A Guide for SaaS Vendors: Gaining Competitive Advantage with MySQL
- MySQL Cluster Benchmarks: Oracle and Intel Achieve 1 Billion Writes per Minute
- Guide to Scaling Web Databases with MySQL Cluster
- MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB
- MySQL Enterprise Edition Product Guide
- Designing and Implementing Scalable Applications with Memcached and MySQL
Presentations
- How to Analyze and Tune MySQL Queries for Better Performance
- MySQL Cluster 7.4 - What's New
- "State of the Dolphin" Keynote - MySQL Central @ OpenWorld 2014
- MySQL Replication: What's New in 5.7
- MySQL Fabric - MySQL High Availability & Scaling Out More (22) »
- Looking at Performance - What’s New in MySQL Workbench 6.1
- What's New in MySQL 5.7
- MySQL Enterprise Edition
- MySQL Optimizer Overview
- Getting the Best MySQL Performance in Your Products: Part IV, Partitioning
- Getting the Best MySQL Performance in Your Products: Part III, Query Tuning
- Getting the Best MySQL Performance in Your Products: Part II, Beyond the Basics
- Getting the Best MySQL Performance in Your Products: Part I, The Basics
- Optimizing MySQL Scalability and Performance
- Profiling with the Performance Schema
- Profiling and Tuning with MySQL 5.6
- MySQL 5.6 Replication: Enhancing Slave Performance and Consistency
- MySQL 5.6 Replication: Binary Log Scalability & Group Commit
- MySQL 5.6 Replication: Supporting High Scale Web & Cloud Services
- MySQL Replication Tricks & Tips
- The MySQL Roadmap: Discover What’s New
- MySQL Enterprise Edition: Thread Pool
- It Just Works! The Beauty of MySQL as an Embedded Database
- MySQL Replication for High Availability and Scalability
- MySQL Performance & Reporting
- MySQL Cluster : Delivering Breakthrough Performance
- MySQL Web Reference Architectures for Building Massively Scalable Web Infrastructure
Case Studies
- Sony Boosts Competitiveness, Improves Customer Confidence, and Enhances Support
- Fabrikant.ru Enjoys Near-Zero Downtime
- Gina Tricot Scales Online Sales with MySQL Enterprise Edition
- Atos Manages Transaction Clearing for the Euronext Markets in Continental Europe with MySQL Enterprise Edition
- After 10 Years, MySQL Still Best for ScienceLogic's Growing Data Demands More (68) »
- IOOF Cuts Time to Complete Online Trades from Days to Seconds with MySQL
- Callis Technologies Optimizes Customers’ Offerings with Real-Time Services Management, Thanks to Scalable Database Platform
- Big Fish Selects MySQL Cluster for Real-Time Web Recommendations
- PayPal Powers its Global Fraud Detection System with MySQL Cluster
- MySQL Cluster Powers El Chavo from Playful Play, Latin America's Most Popular Facebook Game
- Verizon Wireless Supports its Mission-Critical Employee Portal with MySQL
- Emblacom Oy Maximizes Database Availability and Reduces Costs with MySQL Cluster CGE
- Polystar Improves Telecom Networks Performance with Embedded MySQL
- Waiting Room Solutions Relies on MySQL for Web-Based Medical Management Systems
- iStockphoto Grows to a Top-100 U.S. Website with MySQL Enterprise Unlimited
- Zillow.com Deploys MySQL Cluster for High Growth with High Availability
- Zappos Uses MySQL to Power its Growth & Exceptional Customer Service
- Wikipedia's MySQL databases handle over 25,000 SQL queries per second
- Gumtree Relies on MySQL Enterprise to Help Tame Explosive Growth
- F5 Relies on MySQL to Improve Performance 1000%
- Tralix Delivers High SLAs and Extreme Performance with MySQL
- MySQL Powers the Market Leading Telecoms Network Management Framework
- Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator
- Adobe Relies on MySQL to Make Creative Professionals More Productive
- MySQL Cluster Scores with Pyro and Cell C at the FIFA World Cup
- MySQL Enterprise powers 2 Million Referrals in Central Hospital Registry
- MySQL Cluster Powers Leading Document Management Web Service
- Promovacances.com boosts its performance with MySQL Enterprise & the Query Analyzer
- UCR Selects MySQL Enterprise to Power the Medical Registries of 1.5 Million Patients
- MySQL Enterprise powers SaaS ERP for Italian local and central authorities
- Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information
- Cashpoint Saves Half a Million Euros per Year as it Bets on MySQL
- Symantec Benefits from MySQL Embedded Server's Rock-Solid Quality and Low Administrative Costs For Over Six Years
- be2 scales fast growing matchmaking web site with MySQL Enterprise
- MySQL Cluster Powers Rapidly Growing eCommerce Service
- Ticketmaster.com Migrated from Microsoft SQL Server to MySQL and Improved Scalability by 400%.
- Caspur relies on MySQL Enterprise to support its scientific research
- TweetMeme Manages Explosive Growth with MySQL Enterprise
- MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction
- thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
- MySQL Delivers 50% Lower Database Costs as NetHawk Develops Network Monitoring Solutions
- Tema Networks Selects MySQL Embedded Server to Power its Real Time Mobile Billing Solution
- KURIER.at Powers its High-Traffic News Portal with MySQL Cluster
- SPEECH DESIGN Delivers Next Generation Call Completion Services with MySQL Cluster
- Xceedium Relies on MySQL Embedded Server's Resilience and Performance for Its High-Risk User Security Appliance
- Clickability Dramatically Improves Performance and Scalability with MySQL Query Analyzer
- Big Fish Games Triples Database Performance with MySQL Query Analyzer
- Shinsei Bank Relies on MySQL and SugarCRM to Radically Accelerate Enterprise Application Deployment
- KACE Relies on MySQL to Deliver Mission-Critical Systems Management Solution
- Italtel enables Networking Convergence using MySQL Cluster Carrier Grade Edition
- CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Gorilla Nation Relies on MySQL to Power its Advertising Network Business Intelligence Platform
- Clickability Delivers Web Content Management SaaS Solution using MySQL
- FairWarning Relies on MySQL to Automate HIPAA Healthcare Security Compliance
- Paggo Relies on MySQL Cluster and Java to Deliver Financial Transactions over Telecom Networks
- Supply Dynamics Delivers Business-Critical SaaS Solution using MySQL
- Logicworks Delivers Managed Database Hosting Service with MySQL Enterprise
- M1 Deploys MySQL Cluster Carrier Grade Solution from hSenid to Improve Telecom Subscriber Revenue
- RightNow Delivers Software as a Service using MySQL
- ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance
- NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
- Pricer Increases Retailer Efficiency with MySQL
- Alcatel-Lucent Delivers Next Generation Converged Services with MySQL Cluster Carrier Grade Edition
- Quantel
- Alcatel-Lucent uses MySQL Cluster Carrier Grade Edition to Handle over 60 million Subscribers
- Aastra Telecom Schweiz Delivers Highly Reliable Telecom Equipment using MySQL
- Deal Group Media scales out online advertising with MySQL
- Alcatel-Lucent utilise MySQL Cluster Carrier Grade Edition pour gérer plus de 60 millions d'abonnés
- BBC News Website uses MySQL to Monitor Reader Interest
- Bredbandsbolaget (B2) Makes the Connection with MySQL Cluster
- Utel handles 10,000 Requests per Second Using a Scale out Deployment of MySQL Network
- Jajja Communications Optimizes Search Engine Traffic with MySQL Network
- Local County Government Turns to MySQL to Help Support its Citizens
Webinars
- Performance schema and Sys schema in MySQL 5.7 (2016-06-15)
- MySQL in SaaS, Part II: Effective Monitoring for increased Performance, Security & Uptime (2016-02-23)
- MySQL in SaaS, Part I: Security, Performance & Availability (2016-01-25)
Demos
- Remotely Monitor MySQL in the Cloud
- Performance Tuning with MySQL Query Analyzer
- Real-time MySQL Performance & Availability Monitoring
- Installing MySQL Enterprise Monitor
Articles
- MySQL 5.6: Improvements in Thread Pool
- What's New in MySQL 5.6 Release Candidate
- MySQL 5.6 Replication - Enabling the Next Generation of Web & Cloud Services
- MySQL Cluster 7.2 GA Released, Delivers 1 BILLION Queries per Minute
- What's New in MySQL 5.6 More (10) »
- Introduction to MySQL 5.5
- A deep look at MySQL 5.5 partitioning enhancements
- MySQL Developer, meet “Quan” (aka the MySQL Query Analyzer)
- Getting started with DTracing MySQL
- Allan Packer on performance tuning: Scaling MySQL
- Neelakanth Nadgir on MySQL and ZFS: A File System Revolution
- Vince Carbone on MySQL and DTrace: Dynamically tracing better performance
- MySQL Query Analyzer: Interview with Mark Matthews
- Using Partitioning to Manage Satellite Networks
- Why you want to be good at data modeling