Presentations/Videos

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:

Real Time Data Warehousing Presentation

At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.

The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf.

Video: Partitioning in MySQL 5.1

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. The video is embedded at the bottom of this post, and is also available at youtube at http://www.youtube.com/watch?v=zvN9XI-FraI.

New in MySQL 5.1: The Presentation

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

Pages


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32