Learning

OurSQL Episode 124: When Do You Want It?

This week, we talk about Linux I/O schedulers. Ear Candy is iotop, and At the Movies is learning how to use EXPLAIN.

News
OurSQL is taking the EBU's recommendation for volume for mobile devices. You can find a link to a white paper titled: "On the way to loudness nirvana".

Events
Oracle is doing a small MySQL tech tour, on January 22nd to Pleasanton, CA and on January 23rd to Belmont, CA.

OurSQL Episode 121: Fun with text files

This week we discuss manipulating text data and the CSV storage engine. Ear Candy is Venn Diagrams visually showing joins, and At the Movies is about how to retain your individuality while being on a team.

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping out because of Open Database Camp. Registration is free, register today!

OurSQL Episode 120: Trigger Happy

This week we discuss triggers in MySQL. Ear Candy is SQL in the Shell, and At the Movies is Project Triage and Recovery, by Keith Casey of Twilio, at the 2012 CodeConnexx conference.

FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping out because of Open Database Camp. Registration is free, register today!

OurSQL Episode 119: I Do DECLARE

This week we talk more about stored routines, including the several different DECLARE statements. Ear Candy is about ssh hacks to make logging into multiple servers easy, and At the Movies is "Everything You Ever Wanted to Know About Deployment But Were Afraid to Ask".

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

OurSQL Episode 117: Foreign Policy

This week, we take a look at foreign keys - what they are, what you can do with them, and how to troubleshoot the dreaded errno 150. In Ear Candy, we talk about Secrets of Success in the Style of GLEE from CodeConnexx this month, where Jennifer Marsman Microsoft's Developer and Platform Evangelism team talks about how to be successful in a tech job, by using popular songs as illustrating points.

OurSQL Episode 109: Starting with the right foot

This week we talk about startup scripts and their gotchas. Ear candy is a startup cache gotcha and at the movies presents an introduction to VoltDB.

Events

Percona Live Santa Clara, 2013 call for papers closes Friday October 12th.

Oracle's "Scale with MySQL" seminars:
near Paris, Tuesday 16 October
Scale with MySQL Seminar, London, Tuesday 30 October

OurSQL Episode 107: Staying concurrent

This week we present what Multi-Version Concurrency Control (MVCC) means, as well as how InnoDB implements it to achieve transactionality and ACID compliance. Ear candy is a GROUP BY performance gotcha, and At the Movies is a FULLTEXT webinar from Percona.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

OurSQL Episode 106: FULLTEXT on ACID

This week we present InnoDB FULLTEXT search. Ear Candy is about SOUNDEX() and SOUNDS LIKE queries, and At the Movies is about FULLTEXT search throwdown by Bill Karwin.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

OurSQL Episode 105: Lost for Words

This week we present the basics of MySQL FULLTEXT search. We talk about the myisam_ftdump utility in Ear Candy, and present an introduction to Sphinx in At the Movies.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

OurSQL Episode 98: MySQL Puppeteering

This week we present using Puppet to manage MySQL. Ear Candy is netcat and At the Movies is a video about the Master High Availability toolkit by Yoshinori Matsunobu.

Feedback
Daniël van Eeden gave us lots of great feedback this week:
Episode 93, which included iotop and ionice in ear candy
CFQ scheduler for Linux
noop scheduler for Linux
deadline scheduler for Linux

Pages