sheeri's blog

Video: Intro to XtraDB, a Scalable InnoDB-based Storage Engine

Video for the presentation at the 2009 MySQL Camp:

Intro to XtraDB, a Scalable InnoDB-based Storage Engine
Ewen Fortune (Percona)

Description:
XtraDB is a storage engine for MySQL based on the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB.

XtraDB includes all of InnoDB’s robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more features, more tunability, more metrics, and more scalability. In particular, it is designed to scale better on many cores, to use memory more efficiently, and to be more convenient and useful. The new features are especially designed to alleviate some of InnoDB’s limitations. Vadim will talk about current status of XtraDB and directions of development.

Video: Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled

The video for the 2009 MySQL Conference presentation:

Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled
Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

Official description

Slides are at http://forge.mysql.com/wiki/Starring_Sakila_-_A_Data_Warehouse_Mini-Tutorial

Video: Using the Event Scheduler

Video for the presentation at the 2009 MySQL Conference:

Using the Event Scheduler: The Friendly Behind-the-Scenes Helper
Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems)

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

Download the PDF slides

Video: Understanding How MySQL Works by Understanding Metadata, part 2

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.

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.

Video: Understanding How MySQL Works by Understanding Metadata, part 1

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.

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.

Video: Sphinx Full-Text Search Engine

Andrew Aksyonoff speaks at the April 2009 Los Angeles MySQL User Group about how to use Sphinx, the free open source full-text search engine.

Description:
Just how do you implement keyword search through that 10-million-row InnoDB table? Meet Sphinx, a blazing fast open source engine that makes it a breeze. We'll talk about what it is, how it works, and when and why use it.

The user group page is at: http://www.meetup.com/lamysql/calendar/9882984/

http://www.youtub

Video: MySQL Sandbox

Giuseppe Maxia speaks at the April 2009 Los Angeles MySQL User Group about MySQL Sandbox and how to use it for simple and complex sandbox scenarios.

Video: MySQL 5.1

Sheeri K. Cabral speaks at the April meeting of the Los Angeles MySQL User Group about What's New in MySQL 5.1 -- 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 an accompanying blog post with more information at http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation

Video: What the MySQL Is This, Anyway?

Giuseppe Maxia and I are in the exact middle of our leg of the MySQL Campus Tour. Yesterday's session is was recorded -- A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).

The video is below:

Tom Kyte Presents: Why Upgrade to Oracle 11g?

Tom Kyte speaks for about an hour on the newest features in Oracle 11g, including how many new features and enhancements there are. The presentation itself can be downloaded from Tom's site and the video can be directly played in your browser on YouTube at http://www.youtube.com/watch?v=25oUes-pMwI or in the embedded video below:

Pages