Monthly Archives: April 2014

OurSQL Episode 183: Map Our Way Around

This week we discuss MySQL and Geographical Information Systems (GIS). Ear candy is how MVCC in InnoDB relates to undo logging and how you can write better queries based on this information. At the Movies is a demo of GIS.
MySQL and MariaDB geographic … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 183: Map Our Way Around

OurSQL Episode 182: Optimizing MariaDB

This week we discuss new optimizer improvements in MariaDB 10. Ear Candy is about the MariaDB threadpool, and At the Movies is Oracle’s Tomas Ulin talking about raising the bar with MySQL.
Events
DB Hangops – every other Wednesay at noon Pacific time
U… Continue reading

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 182: Optimizing MariaDB

OurSQL Episode 181: MariaDB Goodies

This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.
News
MySQL Community Awards 2014: the Winners
MariaDB 10
MariaDB 10.0.1 fe… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 181: MariaDB Goodies

OurSQL Episode 180: Sharing the Load

This week we talk to Justin Swanhart about Shard-Query, a massively parallel processing query engine for MySQL. Ear candy is about mydumper, and At the Movies is “Common Deadly MySQL Development Mistakes.”
Events
Percona Live
DB Hangops – every other W… Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 180: Sharing the Load