This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees.
Changed Defaults in MySQL 5.6
Percona's article about default variable differences in MySQL 5.5 and MySQL 5.6
MySQL 5.6 manual page about changes to server defaults in MySQL 5.6.
This week we discuss new variables in MySQL 5.6. Ear Candy talks about a problem with XFS performance on a Linux kernel, and At the Movies discusses columnar databases.
@eRadical points out a correction to episode 130 - multiple InnoDB buffer pools were new in MySQL 5.5, not MySQL 5.6.
Events
Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.
This week we discuss changed behavior of variables in MySQL 5.6. In ear candy we talk about a cloud-based service to play with SQL on different databases, and At the Movies is Stewart Smith of Percona talking about MySQL in the Cloud as a Service during Linux Conf Australia in Canberra.
Changed behavior of variables in 5.6
boolean variables can be set to ON/OFF 1/0
TRUE/FALSE
Variables with changes:
log_slave_updates
This week we discuss deprecated, removed and ignored variables in MySQL 5.6. Ear Candy is about innodb_file_per_table enabled by default, and At the Movies is "Different MySQL Forks for Different MySQL Folks".
Events
Upcoming MySQL tech tours
Open Database Camp will be part of the Northeast LinuxFest at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. You can register and submit presentations on the opensqlcamp.org website.
…
[Read more]This week, we discuss GTIDs in MySQL 5.6 and how they work with replication. In Ear Candy, we link to an extremely useful resource for complicated MySQL query patterns. In At the Movies, we present The Finer Art of Being a 'Senior' Employee.
Events
Oracle's upcoming webinars:
MySQL Security Enhancements and Important Security
Tips for ISVs and OEMs on Thursday, February 21st.
MySQL Performance and Scalability in Spanish Thursday, February 28th.
This week we begin to discuss replication features in MySQL 5.6. Ear Candy is a LOAD DATA INFILE bug and using CSV to get beyond it; At the Movies is Suzan Bond talking about "The Art of Self-Sourcing".
Events
Oracle's doing more MySQL tech tours. These seminars will be in
the mornings, and are free. They will be on:
Tuesday, February 19th in Petach Tikva,
Israel
Thursday, February 21st in Oslo and Brussels
…
[Read more]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.
This week we present the Sphinx Storage Engine. Ear Candy is a gotcha about setting variables in the configuration file, and At the Movies is a video about MariaDB.
Events
MySQL Connect will be held in San Francisco on
Saturday September 29th and Sunday September 30th. The schedule is now online.
Conferences
FrOSCon will
be held Saturday and Sunday, August 25th - 26th at the University
of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a
small fee for personal attendees, only 5 euros. It is more for
corporate attendees. There will be a MySQL and friends room this
year, as in years past.
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The …
[Read more]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