Tuesday Feb 02, 2010

MySQL University: Optimizing Queries with EXPLAIN

This Thursday (February 4th, 14:00 UTC), Morgan Tocker will talk about Optimizing Queries with Explain. Morgan was a technical instructor at MySQL and works for Percona today.

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 tentative list of upcoming sessions:

  • February 11: MySQL Galera - Multi-Master Replication (Seppo Jaakola & Alex Yurchenko)
  • February 18: Performance Schema: Instrumenting Code (Marc Alff)
  • February 25: Securich - Security Plugin for MySQL (Darren Cassar)
  • March 4: MySQL Column Databases (Robin Schumacher)
  • March 11: Improving MySQL Full-Text Search (Kristofer Pettersson)
By the way, did I mention that we need more speakers to fill up the 2010 schedule? If you'd like to be a speaker, have a look at this blog article!

Friday Dec 05, 2008

MySQL University for up to 100 attendees

Yesterday (December 4th), Sergey Petrunia gave a presentation on what's new in MySQL Optimizer. Unfortunately, the slides didn't show up in the Dimdim presentation area, which also means that the recorded session only has Sergey's voice but not the slides. (I've filed a bug in Dimdim's issue tracker.) However, Sergey kept referring to slide numbers in his talk, so it should be fairly easy (just not as convenient as usual) to follow his recorded presentation.

The slides, together with links to the recording and the chat transcript, can be found on the MySQL University session page.

Next week (Thursday, December 11th), we'll use our brand new commercial Dimdim license to run the session. This includes a new session address / Dimdim URL:

http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity

You can bookmark this one; it will remain valid for all future sessions. Remember, though, that the meeting room will open only 15 minutes before sessions start.

Our new commercial license is for 100 seats, so everybody should be able to join future sessions. (For Sergey's session, we had between 15 and 20 participants. We were still using my free Dimdim account for that session, which limits the number of attendees to 20. I suspect some people couldn't join in. Sorry for that.)

Next week's session will be about the Random Query Generator, a tool that creates random queries that can be sent to the MySQL server. This MySQL University session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow).

 Date Time
Topic Presenter
December 11 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) Random Query
Generator
Philip Stoev
December 18 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) Using DTrace with MySQL
MC Brown

In January, we'll likely continue with a set of sessions on performance and scalabilty – straight from the Sun QA labs. Find the tentative 2009 schedule on the MySQL University home page.

Tuesday Dec 02, 2008

MySQL University: What's new in MySQL Optimizer

This Thursday (December 4th), Sergey Petrunia will highlight what's new in MySQL Optimizer, with a focus on MySQL 5.1. Since Sergey is one of the main developers in charge of MySQL Optimizer, you can expect to get some in-depth insights that only very few people could provide.

This MySQL University session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow). The virtual meeting room will open 15 minutes before the hour. Point your browser to this address.

Here's the MySQL University schedule for the rest of this year. Only two more sessions to go in 2008:

 Date Time
Topic Presenter
December 11 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) Random Query
Generator
Philip Stoev
December 18 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) Using DTrace with MySQL
MC Brown

In January, we'll likely continue with a set of sessions on performance and scalabilty – straight from the Sun QA labs. Find the tentative 2009 schedule on the MySQL University home page.

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