Category Archives: Server Tuning

OurSQL Episode 136: Digging for Information

Posted on April 22, 2013 by podcast

We discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week’s Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.
Events
DB Hangops in May will be Wed May 8th and 2… Continue reading →

Posted in Learning, Performance, Podcasts, Routines, Server Tuning | Comments Off on OurSQL Episode 136: Digging for Information

OurSQL Episode 135: Another Kind of Buffer

Posted on April 13, 2013 by podcast

This week, we explain the InnoDB and Memcached integration in MySQL 5.6. Ear Candy is about the nonexistent 2-step deadlock detection in MariaDB and At the Movies is Colin Charles talking about the features of MariaDB 10.
InnoDB and memcached in MySQL … Continue reading →

Posted in Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 135: Another Kind of Buffer

OurSQL Episode 133: MySQL on Auto-Tune

Posted on April 3, 2013 by podcast

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 v… Continue reading →

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 133: MySQL on Auto-Tune

OurSQL Episode 132: New and Shiny!

Posted on March 24, 2013 by podcast

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 wer… Continue reading →

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 132: New and Shiny!

OurSQL Episode 131: Fresh Variables

Posted on March 15, 2013 by podcast

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 durin… Continue reading →

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 131: Fresh Variables

OurSQL Episode 130: Retired Variables

Posted on March 8, 2013 by podcast

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 Data… Continue reading →

Posted in Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 130: Retired Variables

OurSQL Episode 128: Your Global ID Please

Posted on February 17, 2013 by podcast

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
Ora… Continue reading →

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 128: Your Global ID Please

OurSQL Episode 127: No Sweat Slaves

Posted on February 9, 2013 by podcast

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. Thes… Continue reading →

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 127: No Sweat Slaves

OurSQL Episode 124: When Do You Want It?

Posted on January 18, 2013 by podcast

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 … Continue reading →

Posted in Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 124: When Do You Want It?

OurSQL Episode 123: Storing Bags of Bytes

Posted on January 11, 2013 by podcast

This week we discuss different filesystems and how they work. Ear Candy talks about the “-bibyte” suffix, and At the Movies presents an indexing webinar.
Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 – Sun Feb 3rd.
OSCON 2013 will t… Continue reading →

Posted in General, Podcasts, Server Tuning | Comments Off on OurSQL Episode 123: Storing Bags of Bytes