Monthly Archives: April 2013

OurSQL Episode 137: Playing in the Sandbox

This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.
MySQL Sandbox
MySQL Sandbox
Examples:
MariaDB slave of a master:
make sandbox mysql-tarball… Continue reading

Posted in General, Podcasts | Comments Off on OurSQL Episode 137: Playing in the Sandbox

OurSQL Episode 136: Digging for Information

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

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 134: When Binary’s Not Binary

This week, we take a lighter topic and talk about the many uses and meanings of “binary”. Ear candy is a but about SET GLOBAL SQL_BIN_LOG, and At the Movies is Ariel Weisberg of VoltDB explaining sharding and elastic clustering.
Events
DBA Hangops – a… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 134: When Binary’s Not Binary

OurSQL Episode 133: MySQL on Auto-Tune

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