sheeri's blog

Video: Grand Tour of the Information Schema and its Applications

Video for the presentation at the 2009 MySQL Camp:
Grand Tour of the Information Schema and its Applications
Roland Bouman

Description:
The following topics will be covered:
- Introduction of the information schema and it’s components
- How to generate WIKI documentation from the information schema
- Generating code (triggers, SPs) to maintain a rich history database
- Creating a stored procedure to check violated foreign key constraints
- Creating a stored procedure to create federated tables

http://www.youtube

Video: ScaleDB Storage Engine

Video for the presentation at the 2009 MySQL Conference:

The ScaleDB Storage Engine: Enabling High Performance and Scalability Using Materialized Views and a Shared-Disk Clustering Architecture
Moshe Shadmon (ScaleDB)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7112

Crash Recovery and Media Recovery in InnoDB

Video for the presentation at the 2009 MySQL Conference:
Crash Recovery and Media Recovery in InnoDB
Heikki Tuuri (Innobase / Oracle Corp.)

The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6843

Video: Beginner Guide to Website Performance with MySQL and memcached

Video for the presentation at the 2009 MySQL Conference:

Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009

Video: Top 10 MySQL Pet Peeves and How to Workaround Them

Video for the presentation at the 2009 MySQL Camp:
Top 10 MySQL Pet Peeves and How to Workaround Them
Jeremy Zawodny

Watch it online here:

Video: InnoDB Database Recovery Techniques

Video for the presentation at the 2009 MySQL Camp:
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)

Description:
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool.

This session speaks about Innodb database recovery techniques (apart from recovering from back).

First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.

Video: High Performance Ruby on Rails and MySQL

Video for the presentation at the 2009 MySQL Conference:

High Performance Ruby on Rails and MySQL
David Berube (Berube Consulting)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6942

Video: Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud

Video for the presentation at the 2009 MySQL Conference:

Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud
Thorsten von Eicken (RightScale, Inc)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6912

Unfortunately, this video was cutoff, but most of the presentation is available.

Video: Advanced Query Manipulation with MySQL Proxy

Video for the presentation at the 2009 MySQL Conference

Advanced Query Manipulation with MySQL Proxy
Kay Roepke (Sun Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040

Video: Testing with the MySQL Random Query Generator

Video from the 2009 MySQL Conference presentation:

If You Love It, Break It: Testing MySQL with the Random Query Generator Philip Stoev (Sun Microsystems)

The description is at:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363

Download the presentation slides (ppt).

Pages