Category Archives: Performance

OurSQL Episode 138: The Relevance of Tungsten

This week we discuss Tungsten and MySQL 5.6 replication with friend of the show, Giuseppe Maxia (aka the Data Charmer). Ear Candy is MariaDB’s Cassandra storage engine, and At the Movies is Giuseppe’s “MySQL 5.6 Replication – features and usability” video from Open Database Camp.

Events
DB Hangops in May will be Wed May 8th and 22nd.
Upcoming MySQL tech tours

Training
SkySQL Trainings
Tungsten University trainings

read more

Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 138: The Relevance of Tungsten

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 131: Fresh Variables

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 127: No Sweat Slaves

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 113: A JS API with JDD

While we were at MySQL Connect last month, we interviewed long-time MySQL developer JD Duncan about integrating NoSQL and JavaScript with MySQL. His team developed the Node.js API for MySQL. This week, we present the interview we did. In Ear Candy, we … Continue reading

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 113: A JS API with JDD

OurSQL Episode 108: Legendary Searches

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

Posted in Performance, Podcasts, Query Optimization, Server Tuning | Comments Off on OurSQL Episode 108: Legendary Searches

OurSQL Episode 96: Talking about Nothing

This week we talk about NULLs and how to find the right data type.
Events
OSCon will be held Monday Jul 16th through Friday Jul 20th and has a data track. We did a podcast about OSCon, including a discount code!
MySQL Connect will be held in San Franci… Continue reading

Posted in Learning, Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 96: Talking about Nothing

OurSQL Episode 86: Speed Demon

This week we talk with Martin Farach-Colton of Tokutek about what’s new with TokuDB.
News/Events/Feedback
Oracle announced the MySQL Connect Conference to be held in San Francisco on Saturday, September 29 and Sunday, September 30th. Call for papers an… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 86: Speed Demon

OurSQL Episode 83: The NewSQL World

This week, we talk with Ori Herrnstadt, CTO of Akiban.
MariaDB announced their 5.3 GA and 5.5 alpha releases.
Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.
Percona’s XtraDB cluster announcement
read more Continue reading

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 83: The NewSQL World

OurSQL Episode 81: From the Tool Bench

This week we present the how’s and why’s of benchmarking MySQL.
News/Feedback:
MySQL Cluster 7.2 can do one billion queries per minute, what does that actually mean?
Percona’s XtraDB cluster announcement
XtraDB Cluster at the San Francisco MySQL Meetup… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 81: From the Tool Bench