Tuesday Sep 29, 2009

MySQL University: InnoDB File Formats and Source Code Structure

This Thursday (October 1st, 14:00 UTC), Calvin Sun will give a session on InnoDB Internals: InnoDB File Formats and Source Code Structure. The InnoDB storage engine provides transactions, row-level locking, and automatic crash recovery. Its on-disk files play a pivotal role for those key features. This presentation describes how on-disk files are structured, how compressed tables are organized, and how long variable-length columns are stored. As we develop new features, it is inevitable for file format changes. We will explain how the new file format management works in the InnoDB Plugin.This talk also covers InnoDB source code structure.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
  • October 15: The Spider Storage Engine (Giuseppe Maxia)
  • October 22: Dual Master Setups With MMM (Arjen Lentz)
  • October 29: MySQL scalability on SPARC & INTEL X5500 (Nehalem) (Benoit Chaffanjon)
  • November 12: Gearman for MySQL (Giuseppe Maxia)
  • November 19: memcached Functions for MySQL (UDFs) (Patrick Galbraith)
  • December 3: Practical Full-Text Search in MySQL (Bill Karwin)

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Thursday Sep 24, 2009

MySQL University: Speakers wanted!

We'd like to fill the remaining session slots for MySQL University this year. Currently, there are 7 available slots in 2009, as can be seen here:

http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live session time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset, start a Flash-enabled browser on either Windows, Mac OS X, Linux, or Solaris, perform a 10-minute test with the MySQL University host, and you're ready for the live session. Everything is done through the browser, so you don't even need a telephone.

So it's very simple to be a speaker, but what should you talk about? Well, maybe you already have an interesting topic suggestion (or, even better, a set of slides you can reuse), but you can also have a look at topics suggested by attendees:

http://forge.mysql.com/wiki/MySQL_University#Proposed_Sessions

MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides, audio, and desktop sharing), so if you can't attend the live session you can look at the recording anytime after the session.

Please suggest your session(s) to Stefan Hinz (stefan.hinz@sun.com), and let me know what date and time of the day would be best for you!

Wednesday Sep 23, 2009

MySQL University: Concurrency Control: How It Really Works

This Thursday (September 24th, 14:00 UTC), Heikki Tuuri, the father of InnoDB, will give a session on Concurrency Control: How It Really Works. He'll describe how InnoDB manages concurrency control, so that the system protects data integrity. Beginning with the basics of transaction management, Heikki will include a discussion of the ACID (atomicity, consistency, isolation, and durability) properties, and explain various transaction modes, locking, deadlocks, and more advanced topics such as the impact of next-key (gap) locking, referential integrity, XA (distributed transaction management) support, and more. While the discussion will focus on the InnoDB implementation, many of the concepts presented apply to other database systems and storage engines.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
  • October 15: The Spider Storage Engine (Giuseppe Maxia)
  • November 12:  Gearman for MySQL (Giuseppe Maxia)

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

MySQL University: Architecture of MySQL Backup

Last Thursday (September 17, 13:00 UTC), Lars Thalmann explained the Architecture of MySQL Backup. Lars is leading the MySQL Replication & Backup teams, and has given several MySQL University sessions before.

I was on sick leave last week and forgot to announce this session - sorry!  However, since the session was recorded (video & audio), you can listen to it anytime. Please find the recording and the presentation slides on this page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • September 17: Architecture of MySQL Backup (Lars Thalmann)
  • September 24: Concurrency Control: How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
  • October 15: The Spider Storage Engine (Giuseppe Maxia)
  • November 12:  Gearman for MySQL (Giuseppe Maxia)
The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Thursday Sep 10, 2009

MySQL University: Customizing MySQL Enterprise Monitor

Today (September 10, 13:00 UTC), Mark Leith will show how to customize the MySQL Enterprise Monitor: Customizing MySQL Enterprise Monitor. Mark is a MySQL support manager, and knows Enterprise Monitor by heart.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • September 17: Architecture of MySQL Backup (Lars Thalmann)
  • September 24: Concurrency Control: How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Friday Aug 28, 2009

MySQL University: New features in Connector/NET 6.1

Next Thursday (September 3, 13:00 UTC), we'll resume MySQL University sessions after the summer break with Reggie Burnett, head of Connector/NET development, giving a session on new features in Connector/NET 6.1.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • September 10: Customizing MySQL Enterprise Monitor (Mark Leith)
  • September 17: Architecture of MySQL Backup (Lars Thalmann)
  • September 24: Concurrency Control: How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Wednesday Aug 12, 2009

Backing up with Dar

If you're interested in ways to back up stuff, and haven't tried Dar yet, here's an article on using Dar that I've just published on my personal blog. In short, Dar works very much like Tar, but it's got a built-in feature for slicing up archive files which comes handy when you want to distribute backup files across several media, for example DVDs or hard disks.

Tuesday Jun 30, 2009

MySQL University: Starring Sakila - A Data Warehouse Mini-Tutorial

This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)
  • July 9 through August 27: Semester break
  • September 3: Connector/NET (Reggie Burnett)
  • September 10: Customizing MySQL Enterprise Monitor (Mark Leith)
  • September 17: Architecture of MySQL Backup (Lars Thalmann)
  • September 24: Concurrency Control: How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Wednesday Jun 24, 2009

MySQL University: Recording of last two sessions available now

We've had problems with recordings lately, so the video streams (slides & audio) for these sessions were missing, or incomplete:

June 11, 2009 The New MySQL Release Model Tomas Ulin
June 4, 2009 Boosting Performance With MySQL 5.1 Partitioning Giuseppe Maxia

I'm happy to say that Dimdim (our conferencing system provider) was able to restore the files, so if you've missed either of those sessions, go ahead and look at the video stream!

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)
  • July 9 through September 3: Semester break
  • September 10: Customizing MySQL Enterprise Monitor (Mark Leith)
  • September 17: Architecture of MySQL Backup (Lars Thalmann)
  • September 24: Concurrency Control: How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Tuesday Jun 23, 2009

MySQL University: MySQL Code Contributions

This Thursday (June 25th, 13:00 UTC), Lenz Grimmer will explain how to contribute code to MySQL, in a MySQL University session titled MySQL Code Contributions. Lenz is a member of the MySQL Community Team. His session will give an overview about how code contributions to MySQL should be handled and performed. It will cover the ideal workflow, requirements and available infrastructure and toolchain that potential contributors should be aware of.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)
  • July 9 through September 3: Semester break
  • September 10: Customizing MySQL Enterprise Monitor (Mark Leith)
  • September 17: Architecture of MySQL Backup (Lars Thalmann)
  • September 24: Concurrency Control: How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Monday Jun 08, 2009

MySQL University: The New MySQL Release Model

This Thursday (June 11th, 14:00 UTC), Tomas Ulin will give a MySQL University session on The New MySQL Release Model. Tomas is the MySQL Server Director, and will explain the new MySQL release model which has just recently been announced.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • June 18, 2009: No session scheduled
  • June 25, 2009: MySQL code contributions (Lenz Grimmer)
  • July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)
  • July 9 through September 3: Semester break

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Tuesday Jun 02, 2009

MySQL University: Boosting Performance With MySQL 5.1 Partitioning

This Thursday (June 4th, 14:00 UTC), Giuseppe Maxia will give a MySQL University session on Boosting Performance With MySQL 5.1 Partitioning. Giuseppe is leading the Community team at MySQL and has done various MySQL University sessions before.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia)
  • June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe)
  • June 18, 2009: No session scheduled
  • June 15, 2009: MySQL code contributions (Lenz Grimmer)
  • July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)
  • July 9 through September 3: Semester break

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Monday May 25, 2009

MySQL University: New replication features in MySQL 5.1 and 6.0

This Thursday (May 28th, 14:00 UTC), Lars Thalmann will give a MySQL University session on MySQL Replication: Walk-through of the new 5.1 and 6.0 features. (This session was originally scheduled for May 7th, but had to be put off due to technical problems. Apologies.) Lars is leading the replication and backup teams at MySQL, so this is one of the best opportunities to ask whatever questions you might have about new replication features in MySQL.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia)
  • June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe)
  • June 18, 2009: No session scheduled
  • June 15, 2009: MySQL code contributions (Lenz Grimmer)
  • July 2: Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)
  • July 9 through September 3: Semester break

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones.

Monday May 04, 2009

MySQL University: MySQL replication: new features in MySQL 5.1 and 6.0

This Thursday (May 7th, 14:00 UTC), Lars Thalmann will give a MySQL University session on MySQL Replication: Walk-through of the new 5.1 and 6.0 features. Lars is leading the replication and backup teams at MySQL, so this is one of the best opportunities to ask whatever questions you might have about new replication features in MySQL.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • May 7, 2009: MySQL Replication: Walk-through of the new 5.1 and 6.0 features (Lars Thalmann)
  • May 14, 2009 (tentative): Programming Towards Multi-Core CPUs (Mikael Ronström)
  • May 21, 2009: No session scheduled
  • May 28, 2009: No session scheduled
  • June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia)
  • June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe)
  • June 18, 2009:  Architecture of MySQL Backup (Lars Thalmann)
  • July 2 (tentative): Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions  for the up-to-date list. On that page, you can also find the starting time for many time zones.


Tuesday Apr 28, 2009

MySQL University: Testing multiple servers with MySQL Sandbox

This Thursday (April 30th, 14:00 UTC), Giuseppe Maxia will give a MySQL University session on Testing Multiple Servers With MySQL Sandbox. Giuseppe is the creator of MySQL Sandbox, and has recently announced a new Sandbox version and other interesting changes, for example the --query-analyzer option to make_sandbox (but note the date when this was announced!).

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the schedule for the upcoming weeks:

  • April 30, 2009: Testing Multiple Servers With MySQL Sandbox (Giuseppe Maxia)
  • May 7, 2009: MySQL Replication: Walk-through of the new 5.1 and 6.0 features (Lars Thalmann)
  • May 14, 2009 (tentative): Programming Towards Multi-Core CPUs (Mikael Ronström)
  • May 21, 2009: No session scheduled
  • May 28, 2009: No session scheduled
  • June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia)
  • June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe)
  • June 18, 2009:  Architecture of MySQL Backup (Lars Thalmann)
  • July 2 (tentative): Starring Sakila - a data warehouse mini-tutorial (Roland Bouman)

The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions  for the up-to-date list. On that page, you can also find the starting time for many time zones.

About

mysqlf is a common typo on the #docs IRC channel of the MySQL documentation team. It shows a high (some might say, dangerous) degree of identification with MySQL. Trying to pronounce it will probably result in tongue injuries.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today