A useful article explaining how to identify bottlenecks in a system by using iostat.

Examples of bad queries from Sarah S., MySQL trainer.

In the words of Sheeri: "At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning. The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf Notes: The partitioning part of the MySQL Manual is at: http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html. The functions that are not allowed in partitioning expressions are listed at: http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html We also had an interesting development — according to the manual, an INSERT to a partitioned table that includes values that do not have a partition should insert all values up to the failure point. The example I used (and  []

The MySQL Developer Zone received permission to publish excerpts from the book \"MySQL Database Design and Tuning\" by Robert Schneider, published in 2005 by Sams (ISBN 0672327651). Chapter 18 is a case study that reviews a broad-based collection of performance problems, along with their solutions.(2005-07-15)

The MySQL 5.1 offers new GLOBAL_STATUS information schema tables. These can be used to report certain performance metrics, such as the number of queries processed per certain seconds, NOT overall avg queries per second, Its good to know how much qps in peak hours.

Mysqlconf 2009 talk about Kickfire

Introduction to guaranteed data availability with Continuent Tungsten for MySQL. How to keep data available with automatic seamless failover, automatic slave promotion, avoid data loss, increase database performance and lower cost of data integration. Presented by Robert Hodges, CTO at Continuent.

This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions. The test database uses data published by the US Bureau of Transportation Statistics. Currently, the data consists of ~ 113 million records (7.5 GB data + 5.2 GB index).

Mikael Ronstrom, father of MySQL Cluster, explains the architecture of NDB (MySQL Cluster).

Timour Katchaounov explains the inner workings of the MySQL Optimizer.

Sergey from the MySQL Optimizer team talks about recent developments in the MySQL Optimizer, including: What's new in MySQL 5.1 optimizer, Overview of known optimizer problems in MySQL 5.1, State of new optimizations in MySQL 6.0, Optimizer development beyond 6.0

Stewart Smith, MySQL Cluster support at that time, introduces NDB (MySQL Cluster).

An overview of ZFS, and how to use the functionality of ZFS with MySQL, including performance improvements, to get the best out of ZFS.

Allan Packer from Sun Labs outlines 2009 plans for improving MySQL performance on multi-core systems.

This session describes investigations into performance and scalability of InnoDB when using the binlog for replication, focusing primarily on the replication master. The session will highlight tools and techniques used to reveal scalability bottlenecks within the MySQL and InnoDB code, approaches used to eliminate those bottlenecks, and current results. The discussion will focus on a current prototype patch that achieves substantial throughput increases for read/write workloads, and enables concurrent commits for InnoDB XA transactions. - Note that the video must be downloaded to be able to view it!

Richard Smith from Sun Labs explains how to code for multi-core systems.

Tim Cook from Sun Labs explains issues and opportunities with locking in InnoDB. - Note that the video must be downloaded to be able to view it!

A collection of MySQL cartoons, featuring Sakila in several environments. Includes images for LAMP, Java, performance, Proxy, Forge, Security, University, Speaker, Writer, traveler, wizard, Summer of Code, and the Librarian.

Allan Packer from Sun Labs outlines 2009 plans for improving MySQL performance on multi-core systems.

This session describes investigations into performance and scalability of InnoDB when using the binlog for replication, focusing primarily on the replication master. The session will highlight tools and techniques used to reveal scalability bottlenecks within the MySQL and InnoDB code, approaches used to eliminate those bottlenecks, and current results. The discussion will focus on a current prototype patch that achieves substantial throughput increases for read/write workloads, and enables concurrent commits for InnoDB XA transactions. - Note that the video must be downloaded to be able to view it!