Categories:
Contributing |
Development |
MySQLDevelopment |
MySQLUniversityMySQL University
MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees.
- Sessions are scheduled on Thursdays (see below for times, and check timeanddate.com for your local time) and normally last one hour. The conferencing system we're using is Dimdim – it requires a web browser with Flash and is known to work on Windows, Mac OS X, Linux, and Solaris.
- To join a session, point your browser to this address. Note that the meeting room will open only 15 minutes before the hour.
- For each MySQL University session, there's an individual Wiki page containing links to the presentation slides, the presentation recording (slides and audio), and the chat transcript.
- The awesome logo was created by Mike Zinner.
[edit] Upcoming Sessions
For all upcoming sessions, point your browser to this address. Note that the meeting room will open only 15 minutes before the hour.
| Date | Time | Session Title | Presenter | Host
|
| November 12, 2009
| 14:00 UTC / 6am PST (Pacific) / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT (London) / 15:00 CET (Central Europe) / 17:00 MDT (Moscow) / 19:30 IST (India)
| Gearman for MySQL
| Giuseppe Maxia
| Stefan Hinz
|
| November 19, 2009
| 14:00 UTC / 6am PST (Pacific) / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT (London) / 15:00 CET (Central Europe) / 17:00 MDT (Moscow) / 19:30 IST (India)
| memcached Functions for MySQL (UDFs)
| Patrick Galbraith
| Stefan Hinz
|
| November 26, 2009
| 14:00 UTC / 6am PST (Pacific) / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT (London) / 15:00 CET (Central Europe) / 17:00 MDT (Moscow) / 19:30 IST (India)
| The Spider Storage Engine
| Giuseppe Maxia
| Paul DuBois
|
| December 3, 2009
| 16:00 UTC / 8am PST (Pacific) / 10am CST (Central) / 11am EST (Eastern) / 16:00 GMT (London) / 17:00 CET (Central Europe) / 19:00 MDT (Moscow) / 21:30 IST (India)
| Practical Full-Text Search in MySQL
| Bill Karwin
| Paul DuBois
|
| December 10, 2009 - January 14, 2010
| Winter Break
|
| January 21, 2010
| To be scheduled
|
| January 28, 2010
| To be scheduled
|
[edit] Proposed Sessions
If you'd like to propose a new topic, or if you'd like to give a presentation yourself, please contact Stefan Hinz.
| Session Title | Presenter
|
| Patch Management With Quilt
| Stewart Smith
|
| Checking Threading and Locking With Helgrind
| Stewart Smith
|
| How to Run the Benchmark Suite
| (to be determined)
|
| Server Memory Management (when to use which alloc)
| (Konstantin Osipov or Sergei Golubchik)
|
| Stored Program Execution
| (to be determined)
|
| Prepared Statement Execution
| (Konstantin Osipov)
|
| The MySQL Statement Dispatcher
| (MySQL Runtime Team)
|
| How Pushbuild Works
| (to be determined)
|
| Simple MySQL DB Administration Concepts for MySQL Engineers
| (to be determined)
|
[edit] Previous Sessions
Previous sessions are intended to serve as a knowledge base for engineers and other interested parties. For older sessions, you can find slides (Wiki or PDF format), audio recordings, and chat transcripts, while for most newer sessions there's a combined Flash recording of slides and audio, and optionally a chat transcript.
| Date | Session Title | Presenter
|
| November 5, 2009
| GRAPH computation engine for MySQL
| Arjen Lentz
|
| October 29, 2009
| MySQL scalability on SPARC & INTEL X5500 (Nehalem)
| Benoit Chaffanjon
|
| October 22, 2009
| Dual Master Setups With MMM
| Walter Heck
|
| October 8, 2009
| Building MySQL Releases on Unix
| Jörg Brühe
|
| October 1, 2009
| InnoDB Internals: InnoDB File Formats and Source Code Structure
| Calvin Sun
|
| September 24, 2009
| Concurrency Control: How It Really Works
| Heikki Tuuri
|
| September 17, 2009
| Architecture of MySQL Backup
| Lars Thalmann
|
| September 10, 2009
| Customizing MySQL Enterprise Monitor
| Mark Leith
|
| September 3, 2009
| New Features in Connector/NET 6.1
| Reggie Burnett
|
| July 2, 2009
| Starring Sakila - A Data Warehouse Mini-Tutorial
| Roland Bouman
|
| June 25, 2009
| MySQL Code Contributions
| Lenz Grimmer
|
| June 11, 2009
| The New MySQL Release Model
| Tomas Ulin
|
| June 4, 2009
| Boosting Performance With MySQL 5.1 Partitioning
| Giuseppe Maxia
|
| May 28, 2009
| MySQL Replication: Walk-through of the new 5.1 and 6.0 features
| Lars Thalmann
|
| April 30, 2009
| Testing Multiple Servers With MySQL Sandbox
| Giuseppe Maxia
|
| April 16, 2009
| Going Nuts - How to write MySQL test cases in Perl
| Luis Soares, Alfranio Correia, Serge Kozlov, Lars Thalmann
|
| April 2, 2009
| How to Create a Test Case (updated session from 2007)
| Patrick Crews
|
| March 19, 2009
| How to Use Charsets and Collations Properly
| Susanne Ebrecht
|
| March 12, 2009
| MySQL and ZFS
| MC Brown
|
| March 5, 2009
| Good Coding Style
| Konstantin Osipov
|
| February 26, 2009
| Backing up MySQL using file system snapshots
| Lenz Grimmer
|
| February 19, 2009
| Developing MySQL on Solaris
| MC Brown & Trond Norbye
|
| February 12, 2008
| Using DTrace with MySQL
| MC Brown
|
| February 5, 2009
| MySQL Performance and Scalability Project - Issues and Opportunities
| Allan Packer
|
| January 29, 2009
| Scalability Challenges in an InnoDB-based Replication Environment
| David Lutz
|
| January 22, 2009
| Scalability by Design - Coding for Systems With Large CPU Counts
| Richard Smith
|
| January 15, 2009
| Low-Level Locking in mysqld and InnoDB - the Good, the Bad, and the Ugly
| Tim Cook
|
| December 11, 2008
| Random Query Generator
| Philip Stoev
|
| December 4, 2008
| What's New in MySQL Optimizer
| Sergey Petrunia
|
| November 20, 2008
| Using memcached in MySQL deployments
| MC Brown
|
| November 13, 2008
| MySQL and OpenSolaris
| MC Brown
|
| November 6, 2008
| Tour of Bazaar and Launchpad for Beginners
| Jay Pipes
|
| October 30, 2008
| Quick and Easy Testing With MySQL Sandbox
| Giuseppe Maxia
|
| October 23, 2008
| Working with PHP and MySQL in NetBeans
| Petr Pisl and David Van Couvering
|
| October 2, 2008 | Checking Performance with Kchachegrind | Stewart Smith
|
| September 11, 2008 | OpenSolaris Web Stack | Jyri Virkki & Murthy Chintalapati
|
| September 4, 2008 | Building MySQL Client Applications | Hartmut Holzgraefe
|
| July 3, 2008 | Advanced LUA Scripting | Giuseppe Maxia
|
| June 12, 2008 | MySQL University MySQL Sandbox | Giuseppe Maxia
|
| May 8, 2008 | Getting Started Using NDB | Stewart Smith
|
| March 27, 2008 | EC2 | Brian Aker
|
| March 6, 2008 | How to Add a Collation | Alexander Barkov
|
| February 28, 2008 | New Optimizer Features in MySQL 6.0 | Sergey Petrunia
|
| February 21, 2008 | Checking Memory With Valgrind | Stewart Smith
|
| February 14, 2008 | Building MySQL on Windows | Ignacio Galarza
|
| February 7, 2008 | C++ Coding Techniques and Principles | Mats Kindahl
|
| January 24, 2008 | Execution of INSERT (DELAYED) and UPDATE statements | Oleksandr Byelkin
|
| December 13, 2007 | Writing LUA Scripts for MySQL Proxy (Abstract) | Giuseppe Maxia
|
| December 6, 2007 | Interaction Between Optimizer and Storage Engine | Sergey Petrunia
|
| November 15, 2007 | How to Run MySQL With a Debugger | Guilhem Bichot
|
| November 8, 2007 | How to Use BitKeeper | Sergei Golubchik
|
| November 1, 2007 | How MySQL Handles ORDER BY, GROUP BY, and DISTINCT | Sergey Petrunia
|
| October 25, 2007 | How to Create a Test Case | Omer BarNir & Matthias Leich
|
| October 18, 2007 | Following a Query Back and Forth in the Server | Sergei Golubchik
|
| October 11, 2007 | Architecture of NDB | Mikael Ronström
|
| September 13, 2007 | MySQL Proxy Overview | Jan Kneschke
|
| September 6, 2007 | How to Build MySQL on Windows | Reggie Burnett
|
| July 19, 2007 | MySQL Memory Handling and Memory Handling in Falcon | Konstantin Osipov and Ann Harrison
|
| June 14, 2007 | Overview of Query Execution and Use of Temp Tables | Monty Widenius
|
| June 7, 2007 | How to Do a Good Code Review | Sergei Golubchik
|
| May 31, 2007 | MySQL Error Handling and Reporting | Tim Smith
|
| May 24, 2007 | Event Scheduler: How it Works and how to Add a Layer on Top of Stored Procedures | Andrey Hristov
|
| May 17, 2007 | Architecture of Falcon | Ann Harrison and Jim Starkey
|
| April 19, 2007 | How the Plugin Interface Works | Brian Aker
|
| April 12, 2007 | Architecture of Backup and Overview of Online Backup Plan | Lars Thalmann, Rafal Somla and Chuck Bell
|
| April 5, 2007 | How Does the MySQL Optimizer Work? | Timour Katchaounov
|
| March 22, 2007 | MySQL Lock Management | Konstantin Osipov
|
| March 15, 2007 | MySQL Storage Handler Interface | Brian Aker
|
| March 8, 2007 | Architecture of Replication | Lars Thalmann
|
| March 1, 2007 | mysys library and algorithms | Sergei Golubchik
|
[edit] Feedback
Primary contact for MySQL University is Stefan Hinz
[edit] Instructions for Moderators
Here are our fail-safe instructions for moderators.
- Schedule a Dimdim test session with the presenter if that person has never used Dimdim before. Make sure the presenter uses a headset with a microphone.
- Go to the Dimdim sign-on page and log in using the MySQL University account credentials.
- On the overview page, start either a pre-scheduled session or a new one ("Host Session"). Start the session 15 minutes before the hour.
- Mute yourself (in Flash) – the host's voice is always garbled for some reason.
- Assign presenter status to the presenter as soon as he arrives.
- Remind the presenter to upload his presentation (PDF or PPT) as early as possible. Note: DimDim apparently imposes a 20MB limited on the size of uploaded files. Large presentations may need to be split into pieces.
- Say hello in the chat, and remind attendees that they can ask questions in the chat window.
- Press the "Recording" button when the presenter is ready to start.
- At the end of the session, thank the presenter and the audience, and say that the session will end now.
- Press the "Stop" button to stop the recording.
- Press the "End Meeting" button to end the meeting. You should be redirected to the overview page.
- On the overview page, click "Search Meetings" to find the meeting you've just hosted.
- After a few minutes, links to the recording and the chat transcript should appear.
- Copy those links to the appropriate MySQL University session page.
[edit] Templates
Here are slide templates that presenters can use. Please convert into PDF format before uploading to the session page.
[edit] Slides and sound tracks licensing
All the material released with MySQL University lessons, unless otherwise indicated in the material itself, is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported License
