Subject: MySQL Newsletter: Special Performance Tuning Edition

From: MySQL AB <[email-masked]>
Date: Tue, 28 Nov 2006 18:59:25 +0100

MySQL Newsletter: Special Performance Tuning Edition
November 2006
[email-masked]

PERFORMANCE TUNING

Welcome to this Special Edition of the MySQL Newsletter. One of the most frequent requests we get at MySQL is more information on Performance Tuning and Performance Benchmarks. Below you will find the most popular technical articles, Webinars, blogs and more on this topic.

Hints & Tips

White Paper: A Look at MySQL 5.0 Performance Benchmarks

White Paper: MySQL Performance Benchmarks

Book Excerpt: High Performance MySQL

MySQL Users Conference 2006 Sessions

Blogs from Planet MySQL

Performance Forum

On-Demand Web Seminars

Web 2.0 Tags and Folksonomy: Schema Design for Scalability and Performance

MySQL Performance Tuning Best Practices (available in English, French, and Italian)

MySQL Performance Tuning: Top 5 Tips

Training & Consulting

Training: MySQL 5.0 Performance Tuning

Training: Performance Tuning and Optimization Workshop

Consulting: MySQL Performance Tuning & Optimization

MySQL Documentation

Chapter 7: Performance Optimization

Hints & Tips

White Paper: A Look at MySQL 5.0 Performance Benchmarks

MySQL 5.0 continues its tradition of being a high-performance RDBMS with version 5.0. The adoption rate of version 5.0 has been extremely high, with polls showing that many users have implemented version in their production environment. One of the reasons cited for making the move was to take advantage of the performance enhancements and new features made available in version 5.0.

Download the White Paper »

White Paper: MySQL Performance Benchmarks

To meet the service levels demanded by your users, your database application needs to deliver high performance and scalability. In addition, it requires complete data availability, which includes fault tolerance, service uptime, and throughput. In short, performance and service uptime are the two most important criteria to ensure an application operates at expected levels. This paper discusses the performance of MySQL. It highlights the database elements that can be measured and adjusted during a benchmark. In addition it delivers a set of benchmark results obtained from third parties and internal tests run at the MySQL Test Labs that demonstrate MySQL's ability to meet the most demanding service levels

Download the White Paper »

Book Excerpt: High Performance MySQL

The authors and publisher of High Performance MySQL have allowed us to post the Server Performance Tuning chapter to our web site. This chapter will help you understand how to tune your server to improve performance, as opposed to tuning schema or queries. This chapter will look at changes to your hardware, operating system, and MySQL configuration to see what effects they have on overall performance.

Read the Server Performance Tuning chapter »

MySQL Users Conference 2006 Sessions

The MySQL Users Conference 2006 featured more than 20 presentations from database experts on MySQL performance tuning. They covered design considerations, techniques and best practices for optimal performance and how to use open source database benchmarks suites.

Download the Presentations »

Blogs from PlanetMySQL

The following are some popular Blog postings available on PlanetMySQL on Performance:

Frank Mash's "MySQL Benchmarking" Series:

http://www.planetmysql.org/entries/3968

http://www.planetmysql.org/entries/3987

http://www.planetmysql.org/entries/4112

Bård Farstad: MySQL Performance Tuning

http://www.planetmysql.org/entries/3965

Domas Mituzas: Open transactions are bad

http://www.planetmysql.org/entries/4054

Peter Zaitsev: ORDER BY ... LIMIT Performance Optimization

http://www.planetmysql.org/entries/4064

Peter Zaitsev: Why an Index could refuse to work

http://www.planetmysql.org/entries/4109

Sheeri Kritzer: How to speed up bulk inserts

http://www.planetmysql.org/entries/4121

Sheeri Kritzer: One TRIGGER Fact, Optimizer Rewriting Stuff

http://www.planetmysql.org/entries/4129

MySQL Performance Forum

To discuss MySQL performance tuning with MySQL experts and users and get great tips, go to

http://forums.mysql.com/list.php?24

On-Demand Web Seminars

Web 2.0 Tags and Folksonomy: Schema Design for Scalability and Performance

This webinar is an examination of the prototypical Web 2.0 concepts and how the database schema lies at the heart of a scalable, high performance modern web application. The content of this webinar is highly technical, with a focus on:

Tag and social networking schema guidelines

Storage engine optimizations for key-mapping tables

Example SQL solutions for common relational problems

Scalable replication scenarios and strategies

Textual indexing considerations (FULLTEXT)

Register for the Web Seminar »

MySQL Performance Tuning Best Practices

Are you experiencing current performance bottlenecks? Designing a new application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?

Then this free web presentation is for you! You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance.

This Web Seminar is available in English, French, and Italian:

Register for this Web Seminar in English »

Register for this Web Seminar in French »

Register for this Web Seminar in Italian »

MySQL Performance Tuning: Top 5 Tips

Do your applications slow down during busy times? Are you having difficulties pinpointing performance bottlenecks? Will finding and fixing performance issues take weeks of time that you just don't have? Then this free web presentation is for you! You will get expert insight and learn the Top 5 Tips to help you improve performance, including:

Schema Optimization

Server Options Tuning

Operation Server Tuning

Hardware Selection and Tuning

Storage Engine Selection

Register for this Web Seminar »

Training & Consulting

Training: MySQL 5.0 Performance Tuning (4 days)

The MySQL 5.0 Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

Learn More and Find a Class Near You »

Training: Performance Tuning and Optimization Workshop (2 days)

Do your applications slow down during busy times? Are you having difficulties pinpointing performance bottlenecks? Will finding and fixing performance issues take weeks of time and expertise that you just don't have? Then this Performance Tuning & Optimization Workshop is for you! You will get expert insight and learn best practices to help you improve performance and scalability.

Learn More and Find a Class Near You »

Consulting: MySQL Performance Tuning & Optimization

MySQL consultants specialize in web applications, data warehouses, clustering, and embedded systems. In this engagement, a dedicated, on-site MySQL certified consultant will work closely with your team, explaining and implementing critical architecture and performance tuning optimization. MySQL consultants have specific expertise in:

MySQL Internals

Query Optimization

Index Tuning

Caching and Buffer Tuning

Hot Spot and Bottleneck identification

This Packaged Solution starts with a 3-day engagement.

Find out More »

MySQL Documentation

Finally, MySQL Documentation includes an entire chapter on performance optimization at:

http://dev.mysql.com/doc/refman/5.0/en/optimization.html

The MySQL Team

Copyright (c) 2006 MySQL AB. All rights reserved.
You are free to distribute this newsletter, as long as you don't make any changes.