Category Archives: Performance

OurSQL Episode 192: Common Schema, part 2

This week we continue our discussion of Common Schema by finishing up the routines and starting to look at the views it offers. Ear Candy is and At The Movies is
News
In the news, the OurSQL podcast will change to a monthly format after episode 200. W… Continue reading

Posted in General, Performance, Podcasts, Routines | Comments Off on OurSQL Episode 192: Common Schema, part 2

OurSQL Episode 190: Server State Monitoring

This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.
News
Gerry:
In the news, the OurSQL podcast will change to a month… Continue reading

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 190: Server State Monitoring

OurSQL Episode 184: Digging Through the Tool Chest

This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.
Events
DB Hangops – every other Wednesay at noon… Continue reading

Posted in General, Learning, Performance, Podcasts | Comments Off on OurSQL Episode 184: Digging Through the Tool Chest

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 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

OurSQL Episode 167: Data, Data Everywhere

This week we discuss test data sets. Ear Candy is errata from Episode 165 on Galera Cluster, and At the Movies is “Runaway Complexity in Big Data”
Test Data Sets
Episode 81, where we talked about different benchmark tools
Sysbench – general version
Per… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 167: Data, Data Everywhere

OurSQL Episode 166: Top Hat Options

This week we discuss fine-tuning Galera Cluster. In this week’s ear candy we talk about recent changes to mysqldump and locking; At the Movies presents “Using Amazon Web Services for MySQL at Scale”.
Events
DB Hangops – every other Wednesay at noon Pac… Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 166: Top Hat Options

OurSQL Episode 165: Top Hat Cluster

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today’s big data transactional… Continue reading

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 165: Top Hat Cluster

OurSQL Episode 158: Know Your Forks

This week we discuss features of Percona Server 5.6 compared to MySQL 5.6. Ear Candy is about pt-upgrade, and At the Movies is a set of lightning talks.
Events
DB Hangops – every other Wednesay at noon Pacific time
Upcoming MySQL events
Percona Live Lo… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 158: Know Your Forks

OurSQL Episode 147: It’s Web Scale

This week we talk with Tim Callaghan of Tokutek about TokuMX, a take on MongoDB. Ear Candy is perror on Windows and At the Movies is a presentation from the SkySQL and MariaDB Solutions Day 2013 about Tokutek.
TokuMX
Replication between MySQL and Mongo… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 147: It’s Web Scale