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 interview Shlomi Noach about the upcoming Percona Live: MySQL Conference and Expo in Santa Clara April 22-25th, 2013. There are 2 organizations with new trainings, too! Ear Candy is a resource with data models, and At the Movies is how to setup and operate Tungsten replication.
Events
Upcoming MySQL tech tours
LinuxFest Northwest will take place in Bellingham, Washington on Sat Apr 27th and Sun Apr 28th.
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 present part 2 of optimizer enhancements in MySQL 5.6, including subquery optimizations and the new optimizer trace feature. Ear Candy talks about what "hole punching" is with regards to file systems. In At the Movies we present "How to Deal with Difficult People".
Events
Galera, SkySQL and MariaDB are doing a Road
Show in Stockholm on February 7th.
Oracle's doing more MySQL tech tours. These seminars will be in
the mornings, and are free. They will be on:
Friday, February 15th near Milan
This week we discuss part 1 of the new optimizer enhancements in MySQL 5.6. Ear Candy is a gotcha about persistent replication configuration, and At the Movies is MVCC in PostgreSQL.
Events
Galera, SkySQL and MariaDB are doing a Road Show in Hamburg on February 1st and Stockholm on February 7th.
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.
OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for speakers closes at midnight Pacific Time on Monday, February 4th.
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 podcast would not achieve its goal if there were no listeners to learn about MySQL. This week we play a bunch of bloopers as our year-end gift to you. We hope these make you laugh!
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 …
[Read more]