High Performance Ruby on Rails and MySQL David Berube (Berube Consulting) From the official conference description is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6942 MySQL is among the fastest relational databases commonly available today; unfortunately, the database alone is only part of the picture. For todays web applications, the one weak link in the entire performance chain from the network to the web application and ending in the database can cause an entire application to seem slow. Unfortunately, Ruby on Rails on exacerbates this problem: Rails makes it easy to develop complicated web applications fast, but it also makes it easy to access your databases in an extremely inefficient manner. Thousands of queries may be generated when just a few are necessary. Even if you can get past that problem, ActiveRecord itself can be a problem: it may create thousands or even millions of  []

Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Download the PDF slides at http://assets.en.oreilly.com/1/event/21/Using%20the%20Event%20Scheduler_%20The%20Friendly%20Behind-the-Scenes%20Helper%20Presentation.pdf From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7115 The Event Scheduler is a framework for executing SQL commands at specific times or at regular intervals. The basics of its architecture are simple. An event is a stored routine with a starting date and time, and a recurring tag. Once defined and activated, it will run when requested. Unlike triggers, events are not linked to specific table operations, but to dates and  []

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x"). And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html The slides can be downloaded as a PDF at http://technocation.org/files/doc/2008_12_New51.pdf or in Open Office presentation format at http://technocation.org/files/doc/2008_12_New51.odp

The ScaleDB Storage Engine: Enabling High Performance and Scalability Using Materialized Views and a Shared-Disk Clustering Architecture Moshe Shadmon (ScaleDB) Slides can be downloaded at http://assets.en.oreilly.com/1/event/21/The%20ScaleDB%20Storage%20Engine_%20%20Enabling%20High%20Performance%20and%20Scalability%20Using%20Materialized%20Views%20and%20a%20Shared-Disk%20Clustering%20Architecture%20Presentation.ppt The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7112

If You Love It, Break It: Testing MySQL with the Random Query Generator by Philip Stoev (Sun Microsystems) The description is at: http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363 Download the presentation slides (ppt) at http://assets.en.oreilly.com/1/event/21/If%20You%20Love%20It,%20Break%20It_%20Testing%20MySQL%20with%20the%20Random%20Query%20Generator%20Presentation.ppt

Sheeri Cabral speaks about the changes in MySQL 5.1 and everything you need to know about upgrading. Get the slides at http://technocation.org/files/doc/2008_12_New51.pdf See the accompanying blog post with more information at http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation

Chasing Bottlenecks by Morgan Tocker Description: The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

At the May 2009 Boston MySQL User Group, Giuseppe Maxia of Sun Microsystems gave a presentation about MySQL 5.4 with use cases and benchmarks to show how it outperforms all other current MySQL releases (including the Percona, OurDelta, and Google releases/patches). The slides are at http://www.slideshare.net/datacharmer/mysql-54-theory-and-practice

Advanced Query Manipulation with MySQL Proxy Kay Roepke (Sun Microsystems) From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040 Currently MySQL Proxy only comes with an incomplete tokenizer for a subset of the MySQL dialect. Many use cases require more knowledge about the query that a stream of tokens can provide and users are force to create their own parsers, most of which are handwritten and simplistic, in Lua. While this is often sufficient for special cases and specific applications, it cannot serve as an extensible and robust framework. For the purpose of query formatting in the MySQL Enterprise Monitor I have written a new parser using ANTLR, where I am a committer in the project. Due to the nature of ANTLR generated recognizers, it is possible to target different implementation languages with little effort and thus has been integrated with  []

Slides are online (and downloadable) at http://www.slideshare.net/Sheeri/scale-db-preso-for-boston-my-sql-meetup-92009 Mike Hogan, CEO of ScaleDB spoke about ScaleDB at the Boston MySQL User Group in September 2009: ScaleDB is a storage engine for MySQL that delivers shared-disk clustering. It has been described as the Oracle RAC of MySQL. Using ScaleDB, you can scale your cluster by simply adding nodes, without partitioning your data. Each node has full read/write capability, eliminating the need for slaves, while delivering cluster-level load balancing. ScaleDB is looking for additional beta testers, sign up at http://www.scaledb.com

Includes: the link to the playlist for all 11 videos plus 11 individual links to each video: Spider: Sharding for the Masses - Giuseppe Maxia A Better mysqltuner - Sheeri Cabral (my session!) Getting acquainted with Apache Derby - Kristian Wagaan New kid on the block: The BlackRay Data Engine — Felix Schupp MySQL High Availability Solutions — Lenz Grimmer Bringing Master/Slave into the 21st Century using Tungsten Database Clustering — Linas Virbalas PBXT: Technology trends that affect your database — Vladimir Kolesnikov MySQL Proxy: a MySQL toolbox - Architecture and concepts of misuse — Jan Kneschke Galera Replication, multi-master synchronous replication for MySQL — Seppo Jaakola Panel Discussion: The OSS Toolshed Shootout Speakers and technologies: Sheeri K. Cabral - MySQL; Holger Klemt - Firebird; Felix Schupp - BlackRay;  []

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  []

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.

Introduction to Continuent Tungsten for MySQL: increasing MySQL performance with advanced high performance parallel replication. Presented by Robert Hodges, CTO at Continuent.

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!

Are you starting a new software project? Don't reinvent the wheel. Before committing to some hand made procedure, you should really consider the combination of Bazaar and Launchpad. Handling the source code is not enough. A software project requires planning, defect handling, coordination between bugs and blueprints, a visual roadmap, and all the above in relation to your code branches. Don't forget about mailing lists, FAQ, documentation, which are integral part of a project. Whether you are participating to an existing project or starting a new one, Launchpad and Bazaar are a powerful combination for your productivity.

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!

Memcached, and how it fits into the typical MySQL environment. - Note that the video must be downloaded to be able to view it!

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!