SPIDER Storage Engine: Database Sharding by Storage Engine by Kentoku SHIBA (ST Global.,Inc) The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6837 Download the presentation file (zip archive) at http://assets.en.oreilly.com/1/event/21/SPIDER%20Storage%20Engine_%20Database%20Sharding%20by%20Storage%20Engine%20Presentation.zip

Optimizing MySQL Performance with ZFS by Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems) The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121 which includes the description

presented at MySQL Camp 2009.

Beginner's Guide to Website Performance with MySQL and memcached Adam Donnison (Sun Microsystems) Download the slides in .ODP format at http://assets.en.oreilly.com/1/event/21/Beginner%27s%20Guide%20to%20Website%20Performance%20with%20MySQL%20and%20memcached%20Presentation.odp The description, taken from the official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009 Memcached is a distributed memory object caching system that is getting a lot of press at the moment for its ability to provide a high-performance front-end for database applications. Sure, memcached can do wonders, but where is it most effective and what are the pain points? When a site grows the site administrator starts to worry about how to maintain performance as the hit count rises. Should extra hardware be thrown at the problem synchronisation issues start to rear their heads. Writing caching code is  []

Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.) Slides are at http://forge.mysql.com/wiki/Starring_Sakila_-_A_Data_Warehouse_Mini-Tutorial From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7016 MySQL is increasingly being adopted for Business Intelligence (BI) and data warehousing (DWH) purposes. Although the technology as such is far from new, there is still quite noticeable confusion and misunderstanding among MySQL Developers and DBAs surrounding key BI/DWH concepts such as denormalization, dimensional modeling, ETL, and OLAP. Even if the concepts are clear, it is still not clear what the purpose is of a datawarehouse, and what problems it can solve. The Sakila database is a simple, publicly available sample database of a DVD rental business,  []

Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial. Part 2 is at http://www.youtube.com/watch?v=C_Uv_4I9gus The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf. From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682: We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method. Examples: Understanding the query_cache% system variables and Qcache% status variables helps us learn about the query cache—what it is, when it is used, how to examine query cache efficiency, how to tune the query cache. This relates to the GLOBAL_VARIABLES and GLOBAL_STATUS system  []

Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial. Part 2 is at http://www.youtube.com/watch?v=V3IBVsYGdtA The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf. From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682: We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method. Examples: Understanding the query_cache% system variables and Qcache% status variables helps us learn about the query cache—what it is, when it is used, how to examine query cache efficiency, how to tune the query cache. This relates to the GLOBAL_VARIABLES and GLOBAL_STATUS system  []

Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud Thorsten von Eicken (RightScale, Inc) The slides at http://assets.en.oreilly.com/1/event/21/Tricks%20and%20Tradeoffs%20of%20Deploying%20MySQL%20Clusters%20in%20the%20Cloud%20Presentation The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6912 Unfortunately, this video was cutoff at the beginning, but most of the presentation is available.

Unleash the Power of Your Data Using Open Source Business Intelligence Christopher Lavigne (Breadboard BI, Inc.) The official conference description is at: http://www.mysqlconf.com/mysql2009/public/schedule/detail/5593 Download the PPT slides at http://assets.en.oreilly.com/1/event/21/Unleash%20the%20Power%20of%20Your%20Data%20Using%20Open%20Source%20Business%20Intelligence%20Presentation.ppt

Crash Recovery and Media Recovery in InnoDB Heikki Tuuri (Innobase / Oracle Corp.) From the official conference page at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6843 InnoDB provides a reliable, true-and-tested automatic crash recovery for MySQL database users. It is based on a redo log and write-ahead logging, two techniques that are used in most of the leading database engines in the world. We will explain these techniques in depth, and present some benchmarks of the crash recovery time. InnoDBs media recovery is done from a (hot) backup of a database, using the MySQL binlog to replay the transactions just as they happened originally. We will explain the difference between MySQLs statement-based and row-based replication and binlogging, and how they should be used to ensure a successful replay of transactions.

Map/Reduce and Queues for MySQL Using Gearman Eric Day (Sun Microsystems), Brian Aker (Sun Microsystems, Inc.) The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7346 Download the PDF slides from http://assets.en.oreilly.com/1/event/21/Map_Reduce%20and%20Queues%20for%20MySQL%20Using%20Gearman%20Presentation.pdf

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

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

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.

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